ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option



ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION 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
PARTITION

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06414: target database COMPATIBLE option does not support proxy copy

1 Answers  


QSM-02124: object type in WHERE clause

1 Answers  


ORA-29378: invalid consumer group mapping priorities

1 Answers  


ORA-16168: LGWR network server could not switch to blocking mode

1 Answers  


ORA-30359: Query rewrite is not supported on SYS materialized views

1 Answers  






ORA-22281: cannot perform operation with an updated locator

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


RMAN-06142: DEVICE TYPE cannot be specified with this command

1 Answers  


PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 Answers  


ORA-27040: file create error, unable to create file

1 Answers  


ORA-24078: cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL

1 Answers  


ORA-32505: too many watchpoints

1 Answers  


Categories