What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it

  • Interview Candidate
  • 2
  • 3426

Showing Answers 1 - 2 of 2 Answers

Raja

  • Mar 15th, 2005
 

mutated trigger: example:Table A has an insert trigger.In that Trigger: There is a statement like insert into Table A, which caues mutated trigger.Avoid to have those kind of triggers in the database.

naren

  • Aug 30th, 2005
 

A trigger is said to be mutated when the table on which the trigger is written, is being used inside trigger for DML operation.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions