View disabled Triggers!Urgent!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: View disabled Triggers!Urgent!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Queries:

    1.If any user disables a trigger, then as a DBA how could I trace such a user who had disabled the trigger!

    2.How and what is the approach to define the Normal size,size increases for Indexes,types of Indexes on around 900+ tables.

    Regards,

    Amit.

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi Amit,

    Login as sys or system and execute the following query to find out all disabled trigger for all users

    select trigger_name,table_owner,table_name,status from all_triggers where status = 'DISABLED'

    Regards
    Santosh

  3. #3
    Join Date
    Feb 2001
    Posts
    286

    What about Time element to trace at what time the user disabled the trigger!

    HI!

    Thanks for the reply!


    1.What about Time element to trace at what time the user disabled the trigger!

    How could I enable time element for this!

    Regards,

    Amitstora.

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