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

Oracle 55 Views 0 Min Read

Oracle Error Message

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

Reason for the Error

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.

Solution

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.

Tags: