ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE
PARTITION



ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION..

Answer / guest

Cause: The two tables specified in the EXCHANGE 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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31075: invalid string declaration in XML Schema

1 Answers  


ORA-19501: read error on file "string", blockno string (blocksize=string)

1 Answers  


PLS-00703: multiple instances of named argument in list

1 Answers  


ORA-14108: illegal partition-extended table name syntax

1 Answers  


ORA-16589: Data Guard Connection process detected a network transfer error

1 Answers  






ORA-30485: missing ORDER BY expression in the window specification

1 Answers  


ORA-32146: Cannot perform operation on a null date

1 Answers  


ORA-13260: layer table string does not exist

1 Answers  


ORA-10567: Redo is inconsistent with data block (file# string, block# string)

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


LSX-00264: attribute "~S" is prohibited (may not occur)

1 Answers  


PCC-02418: Array size mismatch between Object and REF host variables

1 Answers  


Categories