Home -> Usenet -> comp.databases.oracle -> HELP: How can I find out how a table got deleted?

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

From: Tyler Schoenke <schoenke_at_mfa.com>
Date: 1995/09/12
Message-ID: <4350tl$s49_at_homer.alpha.net>#1/1 






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.



Thanks,



Tyler Schoenke


--
Tyler Schoenke   McHugh Freeman - Software Engineer   (414)798-8600


Received on Tue Sep 12 1995 - 00:00:00 CEST












Original text of this message