Oracle DDL Trigger to log all database object changes

preview_player
Показать описание
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.

Please like, comment and subscribe. Thank you.
Рекомендации по теме
Комментарии
Автор

hi, nice share. im curious what is your objective? why not choose "enable ddl log" feature ?

nixonguo
Автор

Awesome! Do you mind sharing the modified code for the Trigger?

kevintha
welcome to shbcf.ru