Thursday 15 March 2012

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option

ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION 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 SUBPARTITION

No comments:

Post a Comment