ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option



ORA-14172: invalid ALTER TABLE EXCHANGE SUBPARTITION option..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24502: codepoint length overflows

1 Answers  


RMAN-08087: channel string: started backup set validation

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  


ORA-13346: the coordinates defining an arc are collinear

1 Answers  


ORA-29396: cannot switch group to string

1 Answers  






ORA-39048: Unable to start all workers; only string worker(s) available.

1 Answers  


PCC-02432: Cannot open an external LOB (BFILE) in READ WRITE mode

1 Answers  


ORA-32110: Connection not specified

1 Answers  


RMAN-08151: replaced global script string

1 Answers  


TNS-01111: Log status can either be ON or OFF

1 Answers  


DRG-11524: primary key value is missing

1 Answers  


NNL-00270: Current default domain is "string"

1 Answers  


Categories