ORA-23344: constraint (string.string) does not exist

Cause : A null, misspelled or nonexistent constraint was specified when registering a uniqueness conflict.

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

Register a named constraint for the specified table.

update : 25-04-2017
ORA-23344

ORA-23344 - constraint (string.string) does not exist
ORA-23344 - constraint (string.string) does not exist

  • ora-19248 : XQ0028 - invalid node in document constructor
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-13515 : Error encountered during Database Usage Statistics capture
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-02452 : invalid HASHKEYS option value
  • ora-13911 : Threshold not found
  • ora-13212 : failed to compare tile with the window object
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-29970 : Specified registration id does not exist
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-23495 : serial propagation can not be used for "string"
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-08205 : ora_addr: $ORACLE_SID not set in environment
  • ora-07513 : sscgctl: $deq unexpected return on cancel of term. lock
  • ora-19511 : Error received from media manager layer, error text: string
  • ora-33413 : (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
  • ora-19708 : log destination exceeds maximum length of string characters
  • ora-13039 : failed to update spatial index for element string.string.string
  • ora-26701 : STREAMS process string does not exist
  • ora-10388 : parallel query server interrupt (failure)
  • ora-28554 : pass-through SQL: out of cursors
  • ora-12925 : tablespace string is not in force logging mode
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-30351 : query rewrite does not currently support this expression
  • ora-02848 : Asynchronous I/O package is not running
  • ora-30653 : reject limit reached
  • ora-04011 : sequence string must range between string and string
  • ora-38850 : an enabled thread missing from control file
  • ora-03202 : the scan limit specification is invalid
  • 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.