ORA-01502
ORACLE Data Base MessagesDownload this dictionary
ORA-01502
ORA-01502: index '.' is in direct load state

Oracle8 Server Error MessagesDownload this dictionary
ORA-01502
index str.name is in direct load state
Section: 01500-01699 Oracle Commands Messages
Notes: This section lists messages generated when entering Oracle commands.If you are using Trusted Oracle, see the Trusted Oracle documentation for information about error messages in that environment.

Cause: The specified index was marked invalid by a direct load.

Action: Drop the specified index.


Provided by PB for Oracle Professional.

Oracle Error Messages - Description, Cause and ActionDownload this dictionary
ORA-01502
01502, 00000, "index '%s.%s' or partition of such index is in unusable state"
MERGE: 1489 RENUMBERED TO 1502
*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