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

LFI-01515: truncate() failed.

1 Answers  


RMAN-00565: unable to read input file

1 Answers  


RMAN-08038: channel string: starting piece string at string

1 Answers  


ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page

1 Answers  


PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  






ORA-32165: Cannot get XA environment

1 Answers  


QSM-02124: object type in WHERE clause

1 Answers  


NZE-29052: Write buffer is not empty.

1 Answers  


SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct

1 Answers  


ORA-02443: Cannot drop constraint - nonexistent constraint

1 Answers  


ORA-23612: unable to find tablespace "string"

1 Answers  


ORA-27067: size of I/O buffer is invalid

1 Answers  


Categories