index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Solution ID:ORA-14098

Type: Oracle

Cause

The two tables specified in the EXCHANGE have indexes which are not equivalent

Actions

Ensure that the table with which the partition is being exchanged for is not partitioned or clustered.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/4539516


https://community.oracle.com/message/10851643


https://community.oracle.com/message/4291126


https://community.oracle.com/message/1312693


https://community.oracle.com/message/2817563


https://community.oracle.com/message/10234615


https://community.oracle.com/message/9549595


https://community.oracle.com/message/9598730


Browse all solutions to database errors from Oracle, MS SQL, or MySQL