All Oracle Error CodesOracle DBA Forum

ORA-01502:

index 'string.string' or partition of such index is in unusable state
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
 SubjectReplies
1.Logon Trigger on schema8
2.Index in unusable mode during direct load w/ si...2
3.ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!1
4.ORACLE 9.2.0.5 bug with SQL LOADER direct load !!!1
5.Change init.ora parameter value for another ses...1
6."create index offline"1