ORA-01502

Errores ORA 25/03/2018 11:48

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

Causa: 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.

Acción: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.

COMENTARIOS:

por Anónimo | 24/04/2007 16:03:30

RE: ORA-01502

Sorry, in first mensage I included a code by error.
The problem usually happens when using the Direct Path for the SQL*Loader, Direct Load or DDL operations.
This requires enough temporary space to build all indexes of the table. If there is no enough space in TEMP tablespace, all rows will still be loaded and imported, but the indices are left with STATUS = ‘INVALID’.