Trigger, lost without delete
I encountered a scenario that the trigger was lost, but there wasn't any delete operation on this trigger.
First, I want to know who and when did the trigger be removed, does this information contains in redo log?or any other logs? Is it possible that the system is out-of-memory, then Oracle choose to delete the trigger internally? but I think it should at least leave a message for me.
someone dropped it
unless you have auditing on - you wont find out
no, oracle wouldnt delete it - that would be stupid
till someone drops that trigger
Originally Posted by LKBrwn_DBA
Well, if need arises, you'd surely have to do something like what LKBrwn_DBA
has mentioned in case you don't have auditing turned on.
that's funny, right?. I don't think Larry would be in business with that kind of logic...
Originally Posted by 51dunk
Looking for the greatest evil in the world? Look in the mirror.
Click Here to Expand Forum to Full Width