invalid ALTER TABLE EXCHANGE PARTITION option

Solution ID:ORA-14094

Type: Oracle

Cause

Name of the table to be EXCHANGED has to be followed by [{INCLUDING|EXCLUDING} INDEX][{WITH|WITHOUT} VALIDATION]

Actions

Reenter the statement without TABLESPACE DEFAULT clause.

Try the following links for this error:


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


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


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


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


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