What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
- 1 Answers
- 643 Views
- I also Faced
- E-Mail Answers
Answer / Ratnesh Kumar Verma
A mutating trigger is a trigger that modifies the same table from which an event that fires the trigger originates. This can lead to a situation known as 'mutating table' error in Oracle DB when the trigger is fired in single user mode. To resolve this issue, you have several options:
1. Use DBMS_LOCK package to acquire and release locks before and after the trigger execution.
2. Create a PL/SQL function instead of a trigger to avoid the mutating table error.
3. If possible, change the trigger definition to fire in multi-user mode.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a dba why is this position necessary?
Which function is used to find the largest integer less than or equal to aspecific value?
Which is the best option used to move database from one server to another serve on same network and why?
What database block size should I use?
What does dba stand for in technology?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What is the relation between database and instance?
What are dba privileges?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What happens when the default and temp tablespace clauses are left out from create user statements?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is a database instance?
Oracle General 
