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

Oracle error message numbers and Oracle error codes.
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:

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

Post by jimb »

ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index
Cause: User attempted to create a UNIQUE partitioned index whose sub-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 subpartitioning 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 subpartitioning columns to ensure that the index' subpartitioning columns form a subset of its key columns
Oracle Database Administration Forums
http://www.oracle-forums.com/
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index

Post by xaeresis »

xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index

Post by xaeresis »

Post Reply