Monday, November 07, 2022

Ora-01502 Index String.string or Partition

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

    Oracle Database Error Code Messages ORA-01502 Help About Description;

Index 'string.string' or partition of such index is in unusable state.

    Cause for Error and Problem;

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.

    How to Solve;ORA-01502 index 'string.string' or partition of such index is in unusable state?

    Action for Solve and Fix Ora-01502;

DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.

Next Post Ora-02102;

Ora-02102 PCC: inconsistent cursor cache

0 comments:

Post a Comment

Featured Post

Ora-00921 Unexpected end of SQL Command

 ORA-00921 unexpected end of SQL command     Oracle Database Error Code Messages ORA-00921 About Help Description; Unexpected end of SQL com...

Search This Blog