Re: HELP: How can I find out how a table got deleted?

Tyler Schoenke (schoenke_at_mfa.com) wrote:
: We ran into a small problem today. While some people were working on a table,
: someone accidentally deleted all of the data from it. It will be difficult
: to populate, so it would be nice to find out how it happened. We asked all of
: our team members, and none of them remember deleting from the table. One way
: of avoiding it would have been to put a trigger on the table to move the data
: to a "lost" table, and tag the user's name to it.
 

: Since that wasn't set up, is there any way of knowing who deleted it? Note: it
: may have been from a interactive, or embedded SQL session.

i assume you did not enable any auditing features...

if you have been saving your archive logs, the only way I know of even being close to tracking what happened is to to read those archive logs. There are tools to do this (SQL*Trax is one), and they will help you reconstruct the rows in the table (if they were deleted...if the table is truncated, you SOL) It will not tell you who deleted them, but it can tell you what time.

jc Received on Sat Sep 16 1995 - 00:00:00 CEST