Monitor all DDL Statements at Database Level
Monitor All DDL Statements at Database Level Applies to: Oracle Enterprise Linux – Version: 7 Oracle Database 11gR2 Description: I want to track all DDL statements at Database level. Solution: Following the steps to track all DDL statements at Database level: 1- First to create a Table that store DDL statements CREATE TABLE DDL_MONITOR_DB ( DATE_TIME DATE, DDL_EVENT VARCHAR2(500), OS_USER VARCHAR2(50), MACHINE VARCHAR2(100) ) 2- Create a Trigger at Database level to catches all DDL statements CREATE OR REPLACE TRIGGER DDL_MONITOR AFTER CREATE OR DROP OR TRUNCATE OR ALTER ON DATABASE DECLARE ...