You are here: Home // Oracle 11g // ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

Cause: Name of the table to be EXCHANGED has to be followed by [{INCLUDING|EXCLUDING} INDEX][{WITH|WITHOUT} VALIDATION] See the solution below.

Error solution: Ensure that no options besides INCLDING INDEX or EXCLUDING INDEX are specified with ALTER TABLE EXCHANGE PARTITION

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: CDN Optima transport kraków backup online catering ile zarabia kwejk.pl peb