ORA-14039: partitioning columns must form a subset of key
columns of a UNIQUE index
- 1 Answers
- 3935 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: User attempted to create a UNIQUE partitioned index
whose partitioning columns do not form a subset of its key
columns which is illegal
Action: If the user, indeed, desired to create an index
whose partitioning columns do not form a subset of its key
columns, it must be created as non-UNIQUE; otherwise,
correct the list of key and/or partitioning columns to
ensure that the index' partitioning columns form a subset of
its key columns
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 1 No |
ORA-13854: Tracing for service(module/action) string on instance string is not enabled
ORA-29833: indextype does not exist
ORA-31097: Hierarchical Index not empty
ORA-16537: child count exceeded
ORA-02040: remote database string does not support two-phase commit
ORA-24051: cannot propagate object type payloads that have a REF attribute
DRG-11867: Method Not Suited For Automatic Redirection
PCC-01001: Your Pro*COBOL authorization is about to expire
ORA-01771: illegal option for a clustered table
QSM-02092: mv references a sequence number
PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES
ORA-24203: operation failed, queue table string.string has errors
Oracle Errors 
