You want auditing not triggers.

Set AUDIT_TRAIL parameter in parameter file.
Issue some AUDIT commands such as AUDIT CREATE, AUDIT DROP, AUDIT ALTER.
Maintain your audit trail which will be in your system tablespace.




"Valério "
<oracledba-ezmlms
hield-x82360171.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
05/30/2008 01:05
PM Subject
Create trigger on database change










Hi Experts,



I’d like to know how to create a trigger on database (after create on
database, after drop on database, after alter on database) to save all ddl
executed to a table, i. e., all changes to database will be saved into a
table. How to “capture” the sql being executed?



Thank you all.

Valério



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page