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



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

More Oracle Errors Interview Questions

NZE-29154: deterministic RNG self-test failure

1 Answers  


ORA-24163: dblink is not supported in rules engine DDLs

1 Answers  


PLS-00408: duplicate column 'string' not permitted in INSERT or UPDATE

1 Answers  


RMAN-03029: echo set on

1 Answers  


PLS-00305: previous use of 'string' (at line string) conflicts with this use

1 Answers  






LPX-00270: FTP error: ~s

1 Answers  


PLS-00419: reference to remote attribute not permitted

1 Answers  


ORA-14059: partition "string": INITRANS value must be less than MAXTRANS value

1 Answers  


QSM-01618: equivalence, string, is enabled for text match rewrite only

1 Answers  


CLSR-06500: Invalid input arguments

1 Answers  


ORA-26005: Invalid handle for direct path load

1 Answers  


SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  


Categories