Question: How can I get the date and
time of when a table was dropped? I am not using
Oracle auditing.
Answer: You can use the Oracle LogMiner
facility to scan the redo logs for the drop table DDL.
This is implemented via the dbms_logminer package
but you need to create a LogMiner dictionary
LogMiner dictionary to translate the redo log entries
into readable form to track the
date and time from dropping a table.
See here
for my notes on tracking DDL using LogMiner
(installing and using LogMiner)
