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-38442: The ADT "string" is not in a valid state.

1 Answers  


ORA-09747: pw_detachPorts: server call pws_detach failed.

1 Answers  


ORA-09209: sftget: error reading from file

1 Answers  


TNS-04087: Unable to shutdown atleast one of the gateways.

1 Answers  


PCC-00010: Statement out of place at line number in file string

1 Answers  






ORA-15024: discovered duplicately numbered ASM disk string

1 Answers  


ORA-32809: foreign queue string is already registered

1 Answers  


ORA-02084: database name is missing a component

1 Answers  


ORA-27510: IPC error waiting for a request to complete

1 Answers  


ORA-00306: limit of string instances in this database

1 Answers  


IMG-00560: input format does not support page selection

1 Answers  


ORA-02304: invalid object identifier literal

1 Answers  


Categories