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-07803: slpdtb: invalid packed decimal nibble

1 Answers  


ORA-39097: Data Pump job encountered unexpected error string

1 Answers  


NNL-00223: Statistic counters are next logged in string

1 Answers  


NZE-29110: Invalid PKCS #12 bag type

1 Answers  


EXP-00064: %s is an inner nested table and cannot be exported.

1 Answers  






NNL-00215: Scheduled specified index number's next auto-refresh to occur in string

1 Answers  


ORA-39090: Cannot add devices to file oriented job.

1 Answers  


DRG-10753: invalid memory size string string

1 Answers  


DRG-11716: attempt to add Narrower Term string for non-Preferred Term string

1 Answers  


TNS-00210: Total Pumps Available : number

1 Answers  


ORA-07411: slgfn: full path name too big for supplied buffer.

1 Answers  


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

1 Answers  


Categories