Saturday 17 March 2012

ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE (SUB(PARTITION

ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE (SUB(PARTITION

Cause: The block sizes of the two tables specified in the ALTER TABLE EXCHANGE (SUB(PARTITION statement are different. For index organized tables, either the block sizes of the index or the overflow (or both) do not match.

Action: Ensure that the block sizes of the tables involved in the ALTER TABLE EXCHANGE (SUB(PARTITION statement are the same. For index organized tables, ensure that the block sizes of both the index and the overflow of the two tables match.

No comments:

Post a Comment