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

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

Question Posted / guest

1 Answers
3143 Views
I also Faced
E-Mail Answers

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

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer