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

DGM-16906: Unable to accept commands: no memory

1 Answers  


PROC-00029: Error in logging layer

1 Answers  


TNS-00147: Failed to start a pre-spawned pump.

1 Answers  


RMAN-06161: error when inspecting auxiliary filename: string

1 Answers  


ORA-36160: (XSMXAGGR04) You may not use AGGREGATE on scalar VARIABLE workspace object.

1 Answers  






KUP-02000: wrong message file version (msg number not found)

1 Answers  


ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

1 Answers  


NCR-03024: NCRO: Transport type LIST not supported

1 Answers  


ORA-39050: parameter string is incompatible with parameter string

1 Answers  


RMAN-06032: at least 1 channel of TYPE DISK must be allocated to execute a COPY command

1 Answers  


ORA-14038: GLOBAL partitioned index must be prefixed

1 Answers  


RMAN-06412: no proxy copy channel found

1 Answers  


Categories