Tracing the delete DB object

We encounter abnormal deletion of records in our batch jobs on a particular table. This seems to be
done by an application as the batch job runs several loads/updates and process
using PL/SQL objects on the back-end. A third-party application also does some update/delete
process. Now the obvious question is, is it possible to identify which process/procedure does this.

We want to trap the deleted records. The existing PL/SQL packages doesn't have any info like
DBMS_APPLICATION so that the same can be used in a delete trigger to create a log. Is there any
alternative way to identify which procedure/package does the deletion? It is not possible to
change all the code to find the occurrance of deletes.

Any ideas from Gurus?

Regards.

Bhat

-----Original Message-----
From: CHUCK_HAMILTON_at_qvc.com [mailto:CHUCK_HAMILTON_at_qvc.com] Sent: Friday, May 05, 2000 3:07 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Download data from oracle tables to flat file

It's really not that slow if you do "set termout off" before the select. Also, I'd recommend putting a delimiter like TAB between columns.

--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA


 

                    Balasubramani

                    an M                 To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <sbala_at_hclins        cc:     (bcc: CHUCK HAMILTON/QVC)

                    ys.com>              Subject:     Download data from
oracle tables to flat file                
                    Ext: NA

                    Sent by:

                    root_at_fatcity.

                    com

 

 

                    05/04/00

                    02:38 PM

                    Please

                    respond to

                    ORACLE-L

 

 






Hi all,

Is there any way to unload the data to flat file other than using

spool on
select * from <table_name>

For very large table having thousands of rows, the above technique will be
very slower.

Is there any other way i can unload the data from the tables faster ?
Any kinf of help is appreciated.


Regards,

Balasubramanian .M

--
Author: Balasubramanian M
  INET: sbala_at_hclinsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



-- 
Author: 
  INET: CHUCK_HAMILTON_at_qvc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may