Quick response appreciated(Session Info)

[phraim]

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

[ggnanaraj]

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.