Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Solution ID:ORA-14297

Type: Oracle

Cause

The block sizes of a pair of indexes being exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different.

Actions

Ensure that the number of partitions in the partitioned table is the same as the number of subpartitions in the the composite partition.

Try the following links for this error:


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


https://community.oracle.com/message/3229900


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