ORA-14293: Number of partitioning columns does not match
number of subpartitioning columns



ORA-14293: Number of partitioning columns does not match number of subpartitioning columns..

Answer / guest

Cause: When exchanging a partitioned table with a composite
partition the number of partitioning columns of the table
must match the number of subpartitioning columns of the
composite partition.

Action: Ensure that the number of partitioning columns in
the partitioned table is the same as the number of
subpartitioning columns in the the composite partition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCB-00581: "string" used as both host variable and indicator

1 Answers  


ORA-09754: sppst: invalid process number passed to sppst.

1 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  


LSX-00010: extra element(s) at end of "~S"

1 Answers  


ORA-01620: no public threads are available for mounting

1 Answers  






ORA-29963: missing BINDING keyword

1 Answers  


DRG-11520: error writing to file

1 Answers  


RMAN-06903: backup of datafile string was cancelled

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


IMP-00081: attempt to free unallocated memory

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


ORA-14062: one or more of table's partitions reside in a read-only tablespace

1 Answers  


Categories