ORA-14131: enabled UNIQUE constraint exists on one of the tables

Cause : One of the tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement has enabled UNIQUE constraint(s) defined on it, which prevents EXCHANGE from proceeding.

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

Disable constraints defined on tables referenced in the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement and retry the statement.

update : 23-05-2017
ORA-14131

ORA-14131 - enabled UNIQUE constraint exists on one of the tables
ORA-14131 - enabled UNIQUE constraint exists on one of the tables

  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-07500 : scglaa: $cantim unexpected return
  • ora-09766 : osnmop: buffer allocation failure.
  • ora-06546 : DDL statement is executed in an illegal context
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-12541 : TNS:no listener
  • ora-01286 : start interval required
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-26741 : cannot assemble lobs
  • ora-26762 : Cannot autogenerate name for parameter string because of the following reason: string
  • ora-25470 : duplicate attribute value for variable: string
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-07269 : spdcr: detached process died after exec.
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-28651 : Primary index on IOTs can not be marked unusable
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-23449 : missing user name
  • ora-28580 : recursive external procedures are not supported
  • ora-13625 : %s is an invalid advisor object type.
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-07268 : szguns: getpwuid error.
  • ora-07257 : spdcr: translation error expanding program name.
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-00329 : archived log begins at change string, need change string
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-25235 : fetched all messages in current transaction
  • ora-24186 : wrong object type, could not transform message
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • 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.