Solved

What is one possible explanation?

Posted on 2001-07-17
4
1,019 Views
Last Modified: 2008-02-20
The database has reported the error 'ORA-04091: table <table_name> is mutating, trigger/function may not see it'. What is one possible explanation?  
Choice 1  
 A statement trigger fired by your statement has executed an improperly formed SELECT, resulting in a large cartesian product.  
Choice 2  
 A statement trigger fired by your statement has attempted to select from its triggering table.  
Choice 3  
 You have attempted to change a table currently being updated by a row trigger fired by another user.  
Choice 4  
 A row trigger fired by your statement has attempted to access its triggering table.  
Choice 5  
 Another user has changed a table referenced by a row trigger fired by your statement.  
0
Comment
Question by:Daman
4 Comments
 
LVL 2

Expert Comment

by:RMZ
Comment Utility
[modder]
0
 
LVL 1

Accepted Solution

by:
alx512 earned 0 total points
Comment Utility
[modder]
0
 
LVL 2

Expert Comment

by:vanmeerendonk
Comment Utility
[modder]
0
 
LVL 3

Expert Comment

by:modder
Comment Utility
Hello Daman

I would like to point you to the member agreement. You can find a link to that on the bottom of every page.

Specifically the Guidelines for use, in which it states that Experts Exchange shall not be used for

* violating the guidelines for academic honesty or other unethical behavior.

In other words:

Experts-Exchange is not a homework service. Please stop using it for this purpose.

alx512, I've reduced the points to this question to zero. As you can see you will not get any points for your help.

modder
Community Support Moderator@Experts-Exchange
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now