ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE
SUBPARTITION

Answers were Sorted based on User's Feedback



ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION..

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

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-26003: parallel load not supported for index-organized table string.

1 Answers  


PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


ORA-29527: created Java source string"string"

1 Answers  


NZE-29163: Third party PKI vendor is not supported in FIPS mode.

1 Answers  






ORA-19649: offline-range record recid string stamp string not found in file string

1 Answers  


ORA-13184: failed to initialize tessellation package

1 Answers  


ORA-24128: partition name specified for a non-partitioned object

1 Answers  


RMAN-05006: cannot recover clone standby single tablespaces

1 Answers  


ORA-39024: wrong schema specified for job

1 Answers  


ORA-33074: (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.

1 Answers  


ORA-37007: (AWLISTALL05) number writer

1 Answers  


Categories