Home » SQL & PL/SQL » SQL & PL/SQL » After servererror on database (10g,11g)
After servererror on database [message #568489] Fri, 12 October 2012 04:46 Go to next message
Messages: 132
Registered: November 2011
Senior Member
Hi All,

I have a DBMS_JOB which fails due to unique constraint error while doing fast refresh.

I wrote a After servererror on database trigger to take backup of M$LOG file whenever unique constrint error occur


Q1)If error is being logged in alert log then After servererror on database trigger doesn't trigger. so no bkup,
Is this a normal behaviour because i was under the impression that if any error in DB occurs then "After servererror on database " will catch it?

If i manully try to do fast refersh it works fine

Q2) Is there any other way in Oracle to counter such issue?


Re: After servererror on database [message #568506 is a reply to message #568489] Fri, 12 October 2012 09:00 Go to previous message
Messages: 25531
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

Previous Topic: sending email or not
Next Topic: How to use if exist condition in oracle
Goto Forum:

Current Time: Sun Jul 23 17:51:31 CDT 2017

Total time taken to generate the page: 0.12077 seconds