Auditing

Hi
I want to put some auditing about object changes ,delete and drop object. I read a article on metalink where you can create a trigger which will populate changes in a table but i couldn't find it anymore.

I don't want to do it for some particle tables but want to do on schema base or on database basis.

Can someone suggest me best way to do this.

Ta
UkDBA

If you want to use Triggers...go thru the manuals, you will get an answer.
On Schema,Database u can have only DDL & Database Event Trigs

http://technet.oracle.com/doc/server...ch4h.htm#26408