Re: Drop by accident?

From: Anthony Hogan <ahogan-nospam-_at_iespana.es>
Date: Wed, 29 May 2002 09:15:09 +0000
Message-ID: <3CF49C1D.57795E0F@iespana.es>

It depends on the command used. If a table was dropped then the commit is automatic, as it is for all DDL statements. If a DELETE FROM table was used then whoever issued it should definitely have known what they were doing. Accidents do happen but perhaps a revision of user privileges may help to reduce the frequency. To identify the guilty party you could have a look through v$sqlarea for the parsing_user_id.

hth
Anthony Hogan

"Michael B. Allen" wrote:
>
> How common is it to drop records by accedent? We had ~2000 company
> records zapped today and no one is fessing up. Is it common that someone
> could drop records like that and then type commit without realising it?
>
> --
> http://www.eskimo.com/~miallen/c/jus.c
Received on Wed May 29 2002 - 04:15:09 CDT