ORA-14039: partitioning columns must form a subset of key
columns of a UNIQUE index
- 1 Answers
- 4378 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-06034: NETDNT: connect failed, partner exited unexpectedly
PCC-00008: Invalid WHENEVER action at column number in line number of file string
ORA-22917: use VARRAY to define the storage clause for this column or attribute
ORA-27034: maximum length of ORACLE_SID exceeded
ORA-12092: cannot online redefine replicated table "string"."string"
LSX-00253: branch is empty
RMAN-07500: searching for all files that match the pattern string
NID-00502: TARGET Username/Password (NONE)
ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
ORA-13217: invalid parameters supplied in ALTER INDEX statement
DRG-10702: cannot create or modify preference in another user's schema
ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
Oracle Errors 
