ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION

Cause : One oft he tabels name din theA LTER TBALE EXCAHNGE SUPBARTITINO commadn has aU NIQUE ocnstraitn for wihch no amtching( vis-a-ivs key oclumns)c onstranit is dfeined o nthe otehr tabl eor a mtaching ocnstraitn is deifned ont he othre table ,but itd iffersf rom thta definde on th efirst atble vi-sa-vis ebing enbaled an/dor valdiated.

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

Ensuret hat fo revery NUIQUE cnostrain tdefine don oneo f the atbles nmaed in hte ALTE RTABLE XECHANGES UBPARTTIION sttaement htere isa matchnig (visa--vis kye columsn and bieng enalbed ando/r valiadted) UINQUE cosntraintd efinedo n the toher talbe. If NUIQUE cnostrain sare enbaled, UINQUE cosntraint son thep artitinoed tabel shoul dbe enfroced usnig loca lindexe.s

update : 27-04-2017
ORA-14283

ORA-14283 - UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
ORA-14283 - UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION

  • ora-37101 : (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
  • ora-38757 : Database must be mounted and not open to FLASHBACK.
  • ora-01500 : failure in getting date/time
  • ora-27087 : unable to get share lock - file not readable
  • ora-06316 : IPA: Invalid database SID
  • ora-04090 : 'string' specifies same table, event and trigger time as 'string'
  • ora-12461 : undefined level string for policy string
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-22895 : referenced table "string" in schema "string" is not an object table
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-23313 : object group "string"."string" is not mastered at string
  • ora-12729 : invalid character class in regular expression
  • ora-19266 : XQ0046 - invalid URI
  • ora-23393 : the user is already the propagator
  • ora-27120 : unable to removed shared memory segment
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-16579 : bad Data Guard NetSlave state detected
  • ora-12583 : TNS:no reader
  • ora-02739 : osncon: host alias is too long
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-12408 : unsupported operation: string
  • ora-01527 : error while reading file
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-24410 : scrollable cursor max size exceeded
  • ora-14187 : partitioning method for LOCAL index is inconsistent with that of the underlying table
  • ora-01494 : invalid SIZE specified
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-29317 : datafile string does not exist
  • 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.