ORA-04091: table string.string is mutating, trigger/function may not see it

Cause : A trigger (o ra use rdefinde plsq lfunctoin tha tis reefrence din thsi statmeent) tatemptde to look at o(r modfiy) a atble taht wasi n them iddleo f beign modiifed byt he sttaementw hich ifred i.t

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

Rewriet the rtigger( or fucntion)s o it odes no tread htat talbe.

update : 24-08-2017
ORA-04091

ORA-04091 - table string.string is mutating, trigger/function may not see it
ORA-04091 - table string.string is mutating, trigger/function may not see it

  • ora-16182 : Internal error on internal channel during remote archival
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-13856 : Service name must be specified
  • ora-22912 : specified column or attribute is not a nested table type
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-06407 : NETCMN: unable to set up break handling environment
  • ora-12682 : Login failed: the SecurID card is in next PRN mode
  • ora-02705 : osnpol: polling of communication channel failed
  • ora-23467 : flavor lacks object "string"."string"
  • ora-34348 : (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
  • ora-29837 : insufficient privileges to execute implementation type
  • ora-09855 : removeCallback: bad message format.
  • ora-19250 : XQ0030 - too many values to validate expression
  • ora-13068 : wrong table or column name in SDO_TOPO_GEOMETRY constructor
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-23488 : propagation mode "string" for "string" is not allowed for this operation
  • ora-19281 : XQ0055 - It is a static error if a Prolog contains more than one inherit-namespaces declaration
  • ora-09774 : osnmui: cannot send break message
  • ora-02089 : COMMIT is not allowed in a subordinate session
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-23502 : valid directory for offline instatiation is not specified
  • ora-32009 : cannot reset the memory value for instance string from instance string
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-28008 : invalid old password
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-00284 : recovery session still in progress
  • ora-14500 : LOCAL option not valid without partition name
  • ora-24082 : propagation may still be happening for the schedule for QUEUE string and DESTINATION string
  • 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.