ORA-14039: partitioning columns must form a subset of key
columns of a UNIQUE index



ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-32801: invalid value string for string

1 Answers  


O2U-00205: None of the characters in a type name were legal identifier characters

1 Answers  


RMAN-00557: could not open MSGLOG "string"

1 Answers  


ORA-01281: SCN range specified is invalid

1 Answers  


PLS-00389: table, view or alias name "string" not allowed in this context

1 Answers  






ORA-00568: Maximum number of interrupt handlers exceeded

1 Answers  


QSM-01113: HAVING clause of mv, string, is more restrictive than query

1 Answers  


DRG-51801: failed to seek in file: %(1)

1 Answers  


ORA-06128: NETTCP: unable to create mailbox

1 Answers  


ORA-06950: No error

1 Answers  


ORA-01689: syntax error in clause "string" of string

1 Answers  


RMAN-06451: proxy copy handle=string recid=string stamp=string

1 Answers  


Categories