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

PCC-00089: Invalid Oracle TYPE specification

1 Answers  


ORA-01037: maximum cursor memory exceeded

1 Answers  


ORA-25951: join index where clause cannot contain OR condition

1 Answers  


TNS-04212: Trace Assistant Internal ERROR: NACOM Type Error

1 Answers  


ORA-07622: smscre: $CREATE failure

1 Answers  






ORA-07840: sllfop: LIB$GET_VM failure

1 Answers  


ORA-01779: cannot modify a column which maps to a non key-preserved table

1 Answers  


ORA-07682: sou2os: set kernel dispatch fail err

1 Answers  


ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

1 Answers  


NNL-00041: Object string not in domain string

1 Answers  


ORA-12078: fast refresh of refresh group ID string failed

1 Answers  


ORA-30442: can not find the definition for filter string

1 Answers  


Categories