ORA-04094: table string.string is constraining, trigger may not modify it

Cause : A trigger attempted to modify a table that was constraining for some referential constraint of a parent SQL statement.

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


update : 17-08-2017

ORA-04094 - table string.string is constraining, trigger may not modify it
ORA-04094 - table string.string is constraining, trigger may not modify it

  • ora-00129 : listener address validation failed 'string'
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-23449 : missing user name
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-12639 : Authentication service negotiation failed
  • ora-29393 : user string does not exist or is not logged on
  • ora-08433 : invalid picture type in convert raw to number
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-13603 : The specified parameter string cannot be fetched as a numeric value for task or object string.
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-19704 : file name exceeds maximum length of string
  • ora-29954 : domain index partition is marked LOADING/FAILED/UNUSABLE
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-07210 : slcpu: getrusage error, unable to get cpu time.
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-31056 : The document being inserted does not conform to string
  • ora-01573 : shutting down instance, no further change allowed
  • ora-16102 : remote information is not available on the specified primary
  • ora-13438 : GeoRaster metadata pyramid type error
  • ora-29816 : object being disassociated is not present
  • ora-00471 : DBWR process terminated with error
  • ora-24788 : cannot switch to specified transaction (server type)
  • ora-07204 : sltln: name translation failed due to lack of output buffer space.
  • ora-19271 : XP0051 - invalid atomic type definition
  • ora-06955 : Number of database servers exceed limit
  • ora-13441 : GeoRaster metadata SRS error
  • ora-26028 : index string.string initially in unusable state
  • ora-22607 : image handle already generated
  • ora-38424 : no attribute set currently assigned to the expression set
  • 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.