Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Phantom deletes

Re: Phantom deletes

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Mon, 18 May 1998 18:57:41 -0400
Message-ID: <3560BCE4.DC2ADB9B@oracle-dba.com>


nbindal_at_my-dejanews.com wrote:

> <SNIP>
> To debug this problem we added a trigger (BEFORE DELETE) on this table, to log
> into another dummy table the row that is getting deleted. Is there any way to
> put in this trigger the processid of the client program which is deleting -
> that way we identify the source of problem. Also if anyone has other ideas of
> finding the culprit, it would be very helpful.
>

Assuming the application is not doing a login/logout and then login as schema owner(which peoplesoft i know for sure does, what a pain in the a$$), you can use the pseudo column user to see who is doing the deleting.

hth, joe

--
Joseph S. Testa, Oracle Database Administrator Vice-President Ohio Oracle Users Group, http://www.ooug.org OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is interested in becoming a corporate sponsor for this event, send mailto:vice_pres_at_ooug.org.
Want some remote DBA work done? mailto:teci_at_oracle-dba.com ICQ http://wwp.mirabilis.com/2832230 Received on Mon May 18 1998 - 17:57:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US