Oracle Solution for Error ora-01502
ORA-01502: index 'string.string' or partition of such index is in unusable state
What triggered the Error:
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 operationWhat should we do to fix it:
DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
