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

ORA-02334: cannot infer type for column

1 Answers  


DRG-51804: failed to write to file: %(1)

1 Answers  


ORA-13901: Object string was not found.

1 Answers  


ORA-08441: closed parenthesis missing in picture mask

1 Answers  


NNL-00526: Starts a server using a non-standard executable and optional arguments

1 Answers  






PCC-02021: Found newline while scanning string literal

1 Answers  


ORA-29967: Cannot drop an operator binding with dependent objects

1 Answers  


ORA-14638: cannot MERGE subpartitions in different Range Composite partitions

1 Answers  


RMAN-06563: controlfile or SPFILE must be restored using FROM AUTOBACKUP

1 Answers  


ORA-04940: unsupported optimization of Oracle binary, check alert log for more info

1 Answers  


ORA-22140: given size [string] must be in the range of 0 to [string]

1 Answers  


ORA-25268: didnt dequeue in browse mode with get signature option

1 Answers  


Categories