ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION


Cause:


The block sizes of a pair of corresponding LOB columns of the two tables specified in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are different.



Action:


Ensure that the block sizes of corresponding pairs of LOB columns of the tables involved in the ALTER TABLE EXCHANGE [SUB]PARTITION statement are the same.