Database Administration (MOSC)

MOSC Banner

index names exist in dba_indexes but not in dba_segments

edited Jul 24, 2012 10:30PM in Database Administration (MOSC) 11 commentsAnswered ✓
dear friends,

I'm a little confused about the following behaviour because
in my case I've a schema owner with 28242 Indexes. All index names in the view dba_segments are also  in the view dba_indexes. They are exactly 4276 Indexes.
But I've got lots of indexnames in the view dba_indexes where not exist in the view dba_segments.
I have not any  virtual indexes and the hidden parameter "_use_nosegment_indexes" are not in use. Can any one tell me the reason for this behaviour?

Thank you very much for all suggestions

best regards
Stefan

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