CREATE OR REPLACE TRIGGER audit_ddl_changes
AFTER create OR drop OR alter
ON scott.SCHEMA -- Change SCOTT to your schema name!!!
-- ON DATABASE
INSERT INTO dll_audit_log VALUES
-- Now, let's test it
CREATE TABLE my_test_table (col1 DATE)
DROP TABLE my_test_table
set pages 50000
SELECT * FROM dll_audit_log
Is there a way to obtain this information in a archive log file without
doing a recovery? Problem is that the View (table) was removed by
someone(?? - I suspect tech support). I'm at a lost because of the number of log switches that have occured between the deletion and
the time I noticed that it. I'll need to pull the information from backup.