Create trigger on database change

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


Oracle LazyDBA home page