Home » SQL & PL/SQL » SQL & PL/SQL » truncate table.
truncate table. [message #9220] Mon, 27 October 2003 14:11 Go to next message
Rock
Messages: 18
Registered: February 2002
Junior Member
is there any way to find out who and when a table has got truncated? from logminer ??(i dont think logminer will be of much help)

Thnks
Rock.
Re: truncate table. [message #9222 is a reply to message #9220] Mon, 27 October 2003 23:33 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

It should be possible to see who TRUNCATED the table
using logminer. However, you will not be able to reverse the
truncate. See the DICT_DDL_TRACKING option with
START_LOGMNR()

Best regards.

Frank
Previous Topic: DB slow
Next Topic: Month List to Be displyed
Goto Forum:
  


Current Time: Fri Apr 19 16:33:53 CDT 2024