Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

What is one possible explanation?

Posted on 2001-07-17
4
1,021 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
ID: 6289420
[modder]
0
 
LVL 1

Accepted Solution

by:
alx512 earned 0 total points
ID: 6289772
[modder]
0
 
LVL 2

Expert Comment

by:vanmeerendonk
ID: 6289797
[modder]
0
 
LVL 3

Expert Comment

by:modder
ID: 6293037
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.

Question has a verified solution.

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

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…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

860 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