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

ORA-30196: reserved for future use

1 Answers  


IMP-00055: Warning: partition or subpartition "string":"string" not found in export file

1 Answers  


RMAN-04025: unable to generate a temporary file

1 Answers  


ORA-25284: Invalid value string for string

1 Answers  


ORA-31097: Hierarchical Index not empty

1 Answers  






QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode

1 Answers  


PLS-00636: overriding method requires OVERRIDING keyword

1 Answers  


ORA-07626: smsget: sga already mapped

1 Answers  


ORA-26080: file "string" is not part of table string.string partition string

1 Answers  


NNL-00529: set|show default_domain [<domain_name>] : set|show the current default domain

1 Answers  


LPX-00606: Missing attribute '~1s' in element '~2S'.

1 Answers  


DRG-10305: pipe string is full

1 Answers  


Categories