Finding who truncated the table

From: Karl Arao <>
Date: Wed, 1 Jul 2009 13:30:42 +0800
Message-ID: <>

Hi Guys,

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?

Received on Wed Jul 01 2009 - 00:30:42 CDT

Original text of this message