Finding who truncated the table

One of the production tables of my client was truncated, they just found out this morning when the application users are complaining. Unfortunately, the auditing for their critical tables is turned off. They want to know who invoked that DDL statement.

I was hoping I could use Log Miner for investigation, but I saw this Metalink Note.

Truncate Statement is not Detected by Log Miner

      Doc ID:     168738.1     Type:     PROBLEM
      Modified Date :     19-FEB-2002

Do you have other ideas?

• Karl Arao http://karlarao.wordpress.com

--
http://www.freelists.org/webpage/oracle-l