ORA-01502: index 'string.string' or partition of such index
is in unusable state



ORA-01502: index 'string.string' or partition of such index is in unusable state..

Answer / guest

Cause: An attempt has been made to access an index or index
partition that has been marked unusable by a direct load or
by a DDL operation

Action: DROP the specified index, or REBUILD the specified
index, or REBUILD the unusable index partition

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16764: log tranport service for some standby database unexpectedly offline

1 Answers  


RMAN-06212: Object Type Filename/Handle

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


ORA-22281: cannot perform operation with an updated locator

1 Answers  


RMAN-08535: channel string: looking for autobackup on day: string

1 Answers  


ORA-30087: Adding two datetime values is not allowed

1 Answers   Oracle,


ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

1 Answers  


ORA-07493: scgrcl: lock manager error.

1 Answers  


DGM-16909: Fatal error - quitting...

1 Answers  


ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

1 Answers  


PCC-02426: Incompatible LOB types

1 Answers  


QSM-01584: equivalence, string, has anchor, string, not found in query

1 Answers  


Categories