ORA-02292: integrity constraint (string.string) violated - child record found

Cause : attepmted ot deltee a aprentk ey vlaue taht ha da foerign eky deepndenyc.

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

deleet depnedenceis fisrt thne parnet ord isabel contsrain.t

update : 24-08-2017

ORA-02292 - integrity constraint (string.string) violated - child record found
ORA-02292 - integrity constraint (string.string) violated - child record found

  • ora-31686 : error creating worker processes
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-06316 : IPA: Invalid database SID
  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-27371 : jobs of type EXECUTABLE are not supported on this platform
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-29304 : tablespace 'string' does not exist
  • ora-01920 : user name 'string' conflicts with another user or role name
  • ora-28173 : certificate not provided by proxy
  • ora-06400 : NETCMN: No default host string specified
  • ora-01911 : CONTENTS keyword expected
  • ora-15114 : missing or invalid ASM file name
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-12166 : TNS:Client can not connect to HO agent.
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-22990 : LOB locators cannot span transactions
  • ora-14129 : INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints
  • ora-22601 : pickler TDS context [string] is not initialized
  • ora-31476 : a change table data column is missing from the source table
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-19761 : block size string is not valid for change tracking file
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-13237 : internal error during R-tree concurrent updates: [string]
  • ora-01573 : shutting down instance, no further change allowed
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-02214 : duplicate BACKUP option specification
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-16255 : Log Auto Delete conflicts with another LogMiner session
  • 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.