Oracle Error ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Oracle Error Message

ORA-14297: Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Reason for the Error

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

Solution

Ensure that the block sizes of the corresponding pairs of indexes that need to be exchanged in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same.