Number of partitioning columns does not match number of subpartitioning columns

Solution ID:ORA-14293

Type: Oracle

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.

Actions

Ensure that the two tables do not have PRIMARY KEY constraints defined on any column or disable all PRIMARY KEY constraints on both tables. Then retry the operation.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


Browse all solutions to database errors from Oracle, MS SQL, or MySQL