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 : 28-06-2017
ORA-14283

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

  • ora-07412 : sfaslv: Error getting entry in asynchronous write array.
  • ora-07205 : slgtd: time error, unable to obtain time.
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-30068 : Internal Event to turn on nested
  • ora-08108 : may not build or rebuild this type of index online
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-31095 : cannot generate string : "string.string" already exists
  • ora-29510 : name, string.string, already used by an existing object
  • ora-01673 : data file string has not been identified
  • ora-19617 : file string contains different resetlogs data
  • ora-30735 : cannot create multiple subtables of the same type under a supertable
  • ora-38201 : assert if pin during flush
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-26002 : Table string has index defined upon it.
  • ora-30394 : source statement identical to the destination statement
  • ora-07744 : slemcl: invalid error message file handle
  • ora-16752 : resource guard could not mount standby database
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-19161 : XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
  • ora-01525 : error in renaming data files
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-40106 : positive target value not specified for computing Lift
  • ora-01162 : block size string in file header does not match configured block sizes
  • ora-27058 : file I/O question parameter is invalid
  • ora-07590 : spdde: $DELPRC failure
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-37012 : (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.
  • ora-25332 : Invalid release value string for queue table compatible parameter
  • 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.