Database Administration (MOSC)

MOSC Banner

sys.lob$

edited Jun 8, 2012 12:16AM in Database Administration (MOSC) 5 commentsAnswered
Hello,

I can find out if an index is system generated by querying sys.ind$ and joining with other tables and views, but Lob indexes do not exist in that table. I would like to do a similar query using sys.lob$

In other words, how to find out if a lob index is system generated or not, using sys.lob$?

Thanks,

Rehab

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center