| After servererror on database [message #568489] |
Fri, 12 October 2012 04:46  |
 |
rishwinger
Messages: 101
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
Problem
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?
Thx
Rishwinger
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
