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 |
ORA-14269: cannot exchange partition other than a Range or Hash partition
SQL-02118: Invalid row for a WHERE CURRENT OF operation
ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions
ORA-32107: internal OCI memory allocation failure
ORA-13273: dimension metadata table string does not exist
ORA-00328: archived log ends at change string, need later change string
PCC-02307: void can only be used when single parameter
ORA-19002: Missing XMLSchema URL
NNF-02005: NIS key string does not exist in map string
LSX-00022: unknown namespace prefix "~S"
PCC-02349: precision must be specified for this type
ORA-27013: skgfqdel: cannot delete an open file