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-05-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-23539 : table "string"."string" currently being redefined
  • ora-31622 : ORACLE server does not have string access to the specified file
  • ora-01670 : new datafile string needed for standby database recovery
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-02233 : invalid CLOSE mode
  • ora-29532 : Java call terminated by uncaught Java exception: string
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-28559 : FDS_CLASS_NAME is string, FDS_INST_NAME is string
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-37602 : (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-16526 : unable to allocate task element
  • ora-25146 : EXTENT MANAGEMENT option already specified
  • ora-10665 : Inject Evil Literals
  • ora-13443 : GeoRaster metadata SRS error
  • ora-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-00106 : cannot startup/shutdown database when connected to a dispatcher
  • ora-24329 : invalid character set identifier
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-09743 : smscre: could not attach shared memory.
  • ora-38784 : Cannot create restore point 'string'.
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-16605 : unable to delete template, template is in use
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-09930 : LUB of two labels is invalid
  • ora-07590 : spdde: $DELPRC failure
  • ora-14158 : too many subpartition descriptions
  • ora-06912 : CMX: write error in datarq
  • 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.