ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The two tables specified in the ALTER TABLE EXCHANGE
SUBPARTITION have indexes which are not equivalent
Action: Ensure that the indexes for the two tables have
indexes which follow this rule For every non partitioned
index for the non partitioned table, there has to be an
identical LOCAL index on the partitioned table and vice
versa. By identical, the column position, type and size have
to be the same.
Please add more information about this Error
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / bits
If the indexes doesn't match between tables, use WITHOUT INDEX clause with partition exchange.
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-26003: parallel load not supported for index-organized table string.
PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables
SQL*Loader-00965: Error number disabling constraint string on table string
ORA-29527: created Java source string"string"
NZE-29163: Third party PKI vendor is not supported in FIPS mode.
ORA-19649: offline-range record recid string stamp string not found in file string
ORA-13184: failed to initialize tessellation package
ORA-24128: partition name specified for a non-partitioned object
RMAN-05006: cannot recover clone standby single tablespaces
ORA-39024: wrong schema specified for job
ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
ORA-37007: (AWLISTALL05) number writer