ORA-14039

Creation of Local Unique Partitioned Index Results in ORA-14039 [ID 209146.1]

• symptom: ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
• cause: Local indexes can only be unique if the partitioning key is the part of the index key.