ORA-14064: Index with Unusable partition exists on
unique/primary constraint key
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 |
NID-00131: Control file is not current
ORA-29882: insufficient privileges to execute indextype
ORA-00330: archived log ends at change string, need change string
LPX-00001: NULL pointer
PCC-01003: Invalid continuation at line number in file string
ORA-36726: (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
ORA-16565: duplicate property, syntax error at "string"
ORA-10616: Operation not allowed on this tablespace
TNS-00071: where <command> is one of following:
LSX-00341: ENTITY or ENTITIES type may only be used in attributes
ORA-12624: TNS:connection is already registered
ORA-01590: number of segment free list (string) exceeds maximum of string