tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns

Solution ID:ORA-14096

Type: Oracle

Cause

The two tables specified in the EXCHANGE have different number of columns

Actions

Rebuild the index a partition at a time (using ALTER INDEX REBUILD PARTITION) or drop and recreate the entire index

Try the following links for this error:


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


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


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