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 : 25-05-2017
ORA-14094

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

  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-08193 : Flashback Table operation is not allowed on temporary tables
  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-31204 : DBMS_LDAP: PL/SQL - Invalid LDAP Session.
  • ora-16816 : incorrect database role
  • ora-27550 : Target ID protocol check failed. tid vers=number, type=number, remote instance number=number, local instance number=number
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-01902 : SEGMENT keyword expected
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-15036 : disk 'string' is truncated
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-39167 : Tablespace string was not found.
  • ora-09935 : Unlink of current password file failed.
  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-25314 : a commit-time queue table cannot be migrated to 8.0
  • ora-29810 : inadequate operator privileges
  • ora-06550 : line string, column string: string
  • ora-01769 : duplicate CLUSTER option specifications
  • ora-02365 : error seeking in file: string
  • ora-16620 : one or more databases could not be contacted for a delete operation
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-00210 : cannot open the specified control file
  • ora-01695 : error converting rollback segment string to version 8.0.2
  • ora-00233 : copy control file is corrupt or unreadable
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-07844 : sllfop: LIB$GET_VM failure
  • 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.