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

ORA-13283: failure to get new geometry object for conversion in place

1 Answers  


ORA-27456: not all arguments of program "string.string" have been defined

1 Answers  


ORA-23347: datatype string for column string table string not supported

1 Answers  


ORA-19716: error processing format string to generate name for backup

1 Answers  


ORA-12671: Shared server: adapter failed to save context

1 Answers  






NNO-00251: missing administrative region parameter string

1 Answers  


ORA-30728: maximum number of columns exceeded

1 Answers  


ORA-02727: osnpop: access error on orapop executable

1 Answers  


ORA-25129: cannot modify constraint (string) - no such constraint

1 Answers  


ORA-22891: cannot have multiple columns in REF constraint

1 Answers  


ORA-30740: cannot grant UNDER privilege on this object

1 Answers  


ORA-38442: The ADT "string" is not in a valid state.

1 Answers  


Categories