Well, not directly, only indirectly. When executing DDLs, database dictionary tables are updated, inserted or deleted and those dictionary DMLs are logged. So you actually won't find any 'DROP TABLE ...' in your log miner output, but you'll find "INSERT INTO sys.obj$ (obj#, dataobj#, owner#, name, ...) VALUES(...)"
in the SQL_REDO of the logminer output. So you'll be looking for the above statements where column NAME will reference your dropped table name.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?