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



ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00539: Network or Protocol services are down

1 Answers  


ORA-13702: Snapshot IDs specified by the range [string, string] are equal.

1 Answers  


PLS-00143: duplicate external LANGUAGE specification in subprogram expression

1 Answers  


RMAN-08093: specifying current controlfile for proxy backup

1 Answers  


TNS-01405: Host: string

1 Answers  


ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.

1 Answers  


DRG-11225: Third-party filter timed out.

1 Answers  


TNS-00006: INTCTL: HOST variable is not defined

1 Answers  


ORA-29293: A stream error occurred during compression or uncompression.

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


ORA-10584: Can not invoke parallel recovery for test recovery

1 Answers  


TNS-04016: Connecting to string

1 Answers  


Categories