A drop table produces an entry for the drop and an alter command when auditing is turned on
When auditing is turned on and I do a
select * from ddl_log
* from ddl_logit returns no rows
I then create a table by
create table test2 as select * from v$instance table test2 as select * from v$instance and then query from ddl_log and it returns 1 row for event CREATE. I then drop table test2 and then query from ddl_log and it returns 3 rows for event CREATE above, event DROP (expected), and event ALTER.drop table test2
and then query from ddl_log and it returns 3 rows for event CREATE above, event DROP (expected), and event ALTER.
0