Finding who truncated the table
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 1 Jul 2009 13:30:42 +0800
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?
- Karl Arao
http://karlarao.wordpress.com
Other related posts:
