Wednesday, 14 March 2012

ORA-14063: Unusable index exists on unique or primary constraint key

ORA-14063: Unusable index exists on unique or primary constraint key

Cause: User attempted to add or enable a primary key or unique constraint on column(s) of a table on which there exists an index marked Index Unusable.

Action: Drop the existing index or rebuild it using ALTER INDEX REBUILD

No comments:

Post a Comment