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

DRG-10304: unexpected error sending command(s) to Oracle Text server

1 Answers  


ORA-33449: (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-16770: physical standby database not in read-only state.

1 Answers  


RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?

1 Answers  






NZE-29033: Invalid PFX

1 Answers  


IMP-00023: Import views not installed, please notify your DBA

1 Answers  


ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers  


NNC-00412: invalid name "string"

1 Answers  


ORA-07665: ssrexhd: recursive exception encountered string string string string string string

1 Answers  


ORA-14115: partition bound of partition number string is too long

1 Answers  


ORA-00080: invalid global area specified by level string

1 Answers  


Categories