ORA-14064: Index with Unusable partition exists on
unique/primary constraint key
- 1 Answers
- 4615 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: User attempted to add or enable a primary key/unique
constraint on column(s) of a table on which there exists an
index one or more partitions of which are marked Index Unusable.
Action: Drop the existing index or rebuild unusable
partitions it using ALTER INDEX REBUILD PARTITION
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-19694: some changed blocks were not found in the change tracking file
ORA-02235: this table logs changes to another table already
ORA-36970: (XSRELTBL12) workspace object must be a self-relation.
ORA-13617: The specified task string already executing
PLS-00255: CALL Specification parameters cannot have default values
ORA-28653: tables must both be index-organized
ORA-06441: ssvwatev: Incorrect parameter passed to function call
TNS-00543: internal error
IMG-00921: threshold out of range
ORA-08432: raw data has invalid floating point data
LPX-00280: HTTP error ~s
PCC-02397: VARCHAR declarations not permitted in #include file
Oracle Errors 
