?
Solved

What is one possible explanation?

Posted on 2001-07-17
4
Medium Priority
?
1,031 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

568 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