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-39081: failed to unsubscribe agent string from queue "string"

1 Answers  


ORA-12063: unable to apply transaction from site string

1 Answers  


ORA-38464: expression set is not empty.

1 Answers  


ORA-36652: (XSDUNION11) workspace object is not a string type dimension.

1 Answers  


ORA-25283: either agent's name or address needed for non-repudiation

1 Answers  






ORA-29806: specified binding does not exist

1 Answers  


ORA-32162: Read/Write SQL method not registered

1 Answers  


ORA-00314: log string of thread string, expected sequence# string doesn't match string

1 Answers  


ORA-30500: database open triggers and server error triggers cannot have BEFORE type

1 Answers  


SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion

1 Answers  


TNS-00240: Connection Manager: Logging is now ON

1 Answers  


RMAN-08180: channel string: restore complete, elapsed time: string

1 Answers  


Categories