Oracle DBA, How To, Error, Cause and Action

ORA-14517: subpartition of index 'string.string' is in unusable state

ORA-14517: subpartition of index 'string.string' is in unusable state


Cause:


An attempt has been made to access an index subpartition that has been marked unusable by a direct load or by a DDL operation



Action:


REBUILD the unusable index subpartition

No comments:

Post a Comment

Thanks for your comment.