Hai Valério

Why save it to a table with a trigger, isn't this a bit complicated ?
All the changes are recorded in your redo logs and archives.
Tools like the logminer can analyze the redologs / archives and
give the exact ddl/dml statements which were executed.

You also can setup auditing or fine grained auditing to record every sql on
an table.


Regards

Lars Jans



-----Original Message-----
From: Valério
[mailto:oracledba-ezmlmshield-x82360171.[Email address protected]
Sent: vrijdag 30 mei 2008 19:01
To: LazyDBA Discussion
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