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



ORA-14188: sub-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 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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00404: Column string present more than once in string's INTO TABLE block.

1 Answers  


LPX-00233: namespace prefixes starting with "xml" are reserved

1 Answers  


IMG-00871: unexpected number of seeds

1 Answers  


TNS-12643: Client received internal error from server

1 Answers  


ORA-22615: attribute is not a collection

1 Answers  






ORA-32113: Null object passed

1 Answers  


ORA-00115: connection refused; dispatcher connection table is full

1 Answers  


ORA-23445: missing template site

1 Answers  


PCC-00001: Unable to open file string

1 Answers  


ORA-23490: extension request "string" with status "string" not allowed in this operation

1 Answers  


CLSS-02206: local node evicted by vendor node monitor

1 Answers  


ORA-09909: Malloc of scratch buffer failed.

1 Answers  


Categories