Oracle database error code ORA-14298 – LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

Oracle Database Error Code ORA-14298 Description :
LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
Error 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.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»