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-12815: value for INSTANCES must be greater than 0

1 Answers  


TNS-01191: Failed to initialize the local OS authentication subsystem

1 Answers  


DRG-12006: Plase enter account:

1 Answers  


NID-00134: Datafile "string" is not consistent

1 Answers  


ORA-01639: instance string has no thread assigned to it

1 Answers  






ORA-16086: standby database does not contain available standby log files

1 Answers  


ORA-38482: no elementary attributes defined in the attribute set

1 Answers  


SQL*Loader-00944: error preparing insert statement for table string.

1 Answers  


ORA-24782: Cannot detach from a non-migratable transaction

1 Answers  


ORA-19659: incremental restore would advance file string past resetlogs

1 Answers  


RMAN-08161: contents of Memory Script:

1 Answers  


ORA-24409: client cannot understand the object

1 Answers  


Categories