Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When do Global and Local Indexes becoming UNUSABLE ?

flying_penguinNov 29 2012 — edited Nov 29 2012

RDMS Version : 11.2.0.2
Platfomrm : AIX 6.1

For partitioned tables (RANGE, LIST types ) what are circumstances when a Global or a Local Index become UNUSABLE ? I was told that in some circumstances where the Indexes become UNUSABLE , not even a SELECT query against the table will work. Is this true ?

For partitioned tables with Global Index, the global index will be listed in DBA_INDEXES . Right ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2012

Added on Nov 29 2012

#general-database-discussions

5 comments

2,026 views