Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How do I troubleshoot ORA-04091 error during a script execution

Posted on 2009-04-28
1
Medium Priority
?
637 Views
Last Modified: 2013-12-18
ORA-04091: table SG_ADM.BIB_HOLDINGS is mutating, trigger/function may not see it

ORA-06512: at "SG_ADM.TRIG_MP_MIGRATION", line 9

ORA-04088: error during execution of trigger 'SG_ADM.TRIG_MP_MIGRATION'

ORA-06512: at "SG_ADM.RWT_BIB_HOLDINGS", line 46

ORA-04088: error during execution of trigger 'SG_ADM.RWT_BIB_HOLDINGS'

0
Comment
Question by:sikyala
1 Comment
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 24252948
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question