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

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

Question Posted / guest

1 Answers
4138 Views
I also Faced
E-Mail Answers

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