Wednesday, 14 March 2012

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

Cause: Name of the table to be EXCHANGED has to be followed by ({INCLUDING|EXCLUDING} INDEX(({WITH|WITHOUT} VALIDATION(

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

No comments:

Post a Comment