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 : 19-08-2017
ORA-14283

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

  • ora-32603 : invalid FREEPOOLS LOB storage option value
  • ora-09370 : Windows 3.1 Two-Task driver ORACLE task timed out
  • ora-13064 : relationship information table has inconsistent data for feature table [string]
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-02290 : check constraint (string.string) violated
  • ora-00472 : PMON process terminated with error
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-13457 : GeoRaster cell data error
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-19265 : XQ0045 - invalid or unknown prefix string in function declaration
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-04074 : invalid REFERENCING name
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-22290 : operation would exceed the maximum number of opened files or LOBs
  • ora-16519 : the resource handle is invalid
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-01512 : error renaming log file string - new file string not found
  • ora-12429 : label list range exceeded
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-30203 : Cannot open mesage file
  • ora-14306 : List value 'string' specified twice in partitions 'string', 'string'
  • ora-31070 : Invalid database user ID string
  • ora-25289 : Buffer Already Exists
  • ora-00284 : recovery session still in progress
  • ora-39953 : the range value specified is beyond allowed range
  • 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.