Oracle DDL Trigger to log all database object changes
DBA should track all changes to their production database.
This DDL triggers logs all Oracle databases changes to a custom table.
If TRUNCATE the trigger will ignore.
IF object_type = 'TABLE' the ddl statement such as create/drop/alter is logged.
ELSE log change information without the ddl statement.
The source is originally from link below which I have modified it slightly.
https://stackoverflow.com/questions/5...
Please like, comment and subscribe. Thank you.
Watch video Oracle DDL Trigger to log all database object changes online without registration, duration hours minute second in high quality. This video was added by user Ken Kim 30 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 712 once and liked it 8 people.