ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION

Cause : cannot ALTER TABLE EXCHANGE PARTITION when the partition and the table have a disabled and validated unique constraints AND the unique keys in the partion is not mutually exclusive from the rest of the table.

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

Change the constraint's status.

update : 27-06-2017
ORA-25132

ORA-25132 - UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
ORA-25132 - UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION

  • ora-00032 : invalid session migration password
  • ora-31662 : metadata transform name can not be defaulted
  • ora-07275 : unable to send signal to process
  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-00378 : buffer pools cannot be created as specified
  • ora-30973 : invalid Path Table option for XML Index
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-23324 : error string, while creating deferror entry at "string" with error string
  • ora-06039 : NETDNT: connect failed
  • ora-16570 : operation requires restart of database "string"
  • ora-16112 : log mining and apply stopping
  • ora-29928 : duplicate default selectivity specified
  • ora-02763 : Unable to cancel at least one request
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-22858 : invalid alteration of datatype
  • ora-38734 : Flashback log is inconsistent; belongs to another database.
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-10261 : Limit the size of the PGA heap
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-15191 : Internal ASM testing event number 15191
  • ora-31035 : Could not bind locked resource to path string/string
  • ora-23411 : materialized view "string"."string" is not in refresh group "string"."string"
  • ora-24394 : invalid mode for destroying connection pool
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-37108 : (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.
  • ora-13515 : Error encountered during Database Usage Statistics capture
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-40283 : missing cost matrix
  • 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.