ORA-14039: partitioning columns must form a subset of key
columns of a UNIQUE index
- 1 Answers
- 4402 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 |
QSM-02033: no filter conditions are present in the WHERE clause
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-00151: invalid transaction ID
PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE
ORA-28106: input value for argument #string is not valid
DRG-52101: an invalid session handle was passed to Oracle Text
ORA-25438: invalid variable name: string
NNO-00315: server is listening on address string
ORA-24066: invalid privilege specified
ORA-30731: scope constraint not allowed on nested table column when the nested table is being created
ORA-13900: missing or invalid parameter string
PLS-01404: ANSI Identifiers can only consist of letters, digits, and the underscore character
Oracle Errors 
