Login  Register

index disabled

classic Classic list List threaded Threaded
2 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

index disabled

Roshan
1294 posts
Oracle 19c

Hello,

some indexes were disabled on a few tables. Could you please advise how? I checked audit trail but could not find any hint

FUNCIDX_STATUS shows status as disabled.

Regards,
Roshan
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: index disabled

ErmanArslansOracleBlog
Administrator
5727 posts
FUNCIDX_STATUS is for getting the information about the status of function-based indexes.

Which indexes are disabled?