Quick response appreciated(Session Info)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Quick response appreciated(Session Info)

  1. #1
    Join Date
    Mar 2003
    Posts
    8

    Quick response appreciated(Session Info)

    Hello,

    Please does anyone have an example of a code (trigger or proc) that can capture the session information for any table dropped or truncated in a particular Database schema? Or have an idea of the best way to go about doing that.

    A quick response will be appreciated.

    Thanks
    phraim

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Quick response appreciated(Session Info)

    Originally posted by phraim
    capture the session information for any table dropped or truncated in a particular Database schema
    For 'truncate table' auditing...
    http://download-west.oracle.com/docs...udit.htm#13360

    For examples..'drop' auditing
    http://www.oracle-base.com/Articles/8i/Auditing.asp

    HTH.

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