Trigger, lost without delete
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Trigger, lost without delete

  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Trigger, lost without delete

    Hi all

    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.

    Black Thought

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    someone dropped it
    unless you have auditing on - you wont find out
    no, oracle wouldnt delete it - that would be stupid

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool DDL or no DDL, that is the question.

    Seems you need to tighten up security.

    If necesary, I also recommend you create a DDL trigger to either record and/or prevent schema changes.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by LKBrwn_DBA
    Seems you need to tighten up security.

    If necesary, I also recommend you create a DDL trigger to either record and/or prevent schema changes.
    till someone drops that trigger

  5. #5
    Join Date
    Oct 2006
    Posts
    175
    51dunk
    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.

    Regards,
    gtcol

  6. #6
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    Quote Originally Posted by 51dunk
    Hi all

    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.

    Black Thought
    that's funny, right?. I don't think Larry would be in business with that kind of logic...
    Looking for the greatest evil in the world? Look in the mirror.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width