ORA-14039: partitioning columns must form a subset of key
columns of a UNIQUE index
- 1 Answers
- 4333 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 |
NMP-00002: no such SNMP variable name
ORA-30934: 'string' (string node) cannot be inserted in parent 'string' (string node)
ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications
ORA-30477: The input select_clause is incorrectly specified
ORA-29380: resource plan string is currently active and cannot be deleted
TNS-00065: INTCTL: Command cannot be executed remotely
NZE-29119: Cannot import certificate.
NID-00600: Internal Error - [number] [number] [number] [number]
NCR-04005: NCRR: Invalid procedure handle
RMAN-06407: auxiliary instance datafile string deleted
ORA-09747: pw_detachPorts: server call pws_detach failed.
ORA-13372: failure in modifying metadata for a table with spatial index
Oracle Errors 
