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_log

it 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.