Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-14094 – invalid ALTER TABLE EXCHANGE PARTITION option

Oracle Database Error Code ORA-14094 Description :

invalid ALTER TABLE EXCHANGE PARTITION option

Error Cause:

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

How to Solve :

Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE PARTITION