truncate table. [message #9220] |
Mon, 27 October 2003 14:11 |
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 |
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
|
|
|