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

DGM-16943: You must connect to instance "string" and issue the command again.

1 Answers  


ORA-00255: error archiving log string of thread string, sequence # string

1 Answers  


ORA-28157: Proxy user 'string' forbidden to set role 'string' for client 'string'

1 Answers  


DRG-11801: Continue

1 Answers  


ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

1 Answers  


ORA-19615: some files not found in backup set

1 Answers  


KUP-03021: clause references unknown field string

1 Answers  


ORA-06042: NETDNT: message receive failure

1 Answers  


ORA-15046: ASM file name 'string' is not in single-file creation form

1 Answers  


TNS-00310: Navigator: Failed to start tracing after rereading parameter data

1 Answers  


PCC-00005: Unsupported datatype in line number of file string

1 Answers  


ORA-16126: loading table or sequence string

1 Answers  


Categories