ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE
[SUB]PARTITION
- 1 Answers
- 3159 Views
- I also Faced
- E-Mail Answers
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 |
ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]
ORA-09884: Two Task interface: SID doens't match current PU
RMAN-00563: password too long
ORA-09807: Conversion of label from string to binary failed.
EXP-00000: Export terminated unsuccessfully
ORA-13423: invalid cell coordinate parameter
QSM-02031: materialized view cannot support any type of query rewrite
ORA-27044: unable to write the header block of file
ORA-12815: value for INSTANCES must be greater than 0
ORA-13228: spatial index create failed due to invalid type
ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater
Oracle Errors 
