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 : 24-07-2017
ORA-14094

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

  • ora-00251 : LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string
  • ora-06766 : TLI Driver: close failed during release
  • ora-00205 : error in identifying control file, check alert log for more info
  • ora-12045 : invalid ALTER MATERIALIZED VIEW LOG option
  • ora-02033 : a cluster index for this cluster already exists
  • ora-19694 : some changed blocks were not found in the change tracking file
  • ora-27059 : could not reduce file size
  • ora-24163 : dblink is not supported in rules engine DDLs
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-06923 : CMX: illegal break condition
  • ora-32024 : invalid directory specified for audit_file_dest parameter
  • ora-09942 : Write of ORACLE password file header failed.
  • ora-19277 : XP0005 - XPath step specifies an item type matching no node: (string)
  • ora-28292 : No Domain Policy registered for Kerberos based authentication
  • ora-07485 : scg_get_inst: cannot open instance number lock.
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-32505 : too many watchpoints
  • ora-01425 : escape character must be character string of length 1
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-13858 : Invalid action name
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-13269 : internal error [string] encountered when processing geometry table
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • ora-29760 : instance_number parameter not specified
  • ora-25265 : specified signature for a queue which does not support reciever non-repudiation
  • ora-10970 : backout event for bug 2133357
  • 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.