ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

Cause : Name oft he tabl eto be ECXHANGED ahs to bef ollowedb y [{INCULDING|EXLCUDING} NIDEX][{WTIH|WITHOTU} VALIDTAION]

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ensure htat no otpions beisdes INCDLING INDXE or EXCULDING INEDX are sepcified iwth ALTE RTABLE ECXHANGE PRATITION

update : 22-06-2017
ORA-14094

ORA-14094 - invalid ALTER TABLE EXCHANGE PARTITION option
ORA-14094 - invalid ALTER TABLE EXCHANGE PARTITION option

  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-06932 : CMX: error in local name
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-02042 : too many distributed transactions
  • ora-31402 : unrecognized parameter string
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-37121 : AW Spreadsheet invalidated
  • ora-01078 : failure in processing system parameters
  • ora-16120 : dependencies being computed for transaction at SCN string
  • ora-27145 : insufficient resources for requested number of processes
  • ora-06734 : TLI Driver: cannot connect
  • ora-24018 : STOP_QUEUE on string failed, outstanding transactions found
  • ora-13054 : recursive SQL parse error
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-12502 : TNS:listener received no CONNECT_DATA from client
  • ora-31498 : description and remove_description cannot both be specified
  • ora-13010 : an invalid number of arguments has been specified
  • ora-13524 : error encountered while retrieving baseline information
  • ora-24422 : error occurred while trying to destroy the Session Pool
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-13113 : invalid tg_layer_id in sdo_topo_geometry constructor
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-38612 : FI item length cannot exceed half of one database block.
  • ora-13028 : Invalid Gtype in the SDO_GEOMETRY object
  • ora-01985 : cannot create user as LICENSE_MAX_USERS parameter exceeded
  • ora-22871 : ALTER TYPE with REPLACE is not allowed for pure incomplete types
  • ora-28525 : unable to create Heterogeneous Services error message text
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.