Re: Tracing the delete DB object

If you have 8i, try Log Miner.

Damn cool tool.
----- Original Message -----
From: <LBhat_at_LEVI.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 11, 2000 8:30 AM
Subject: 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-----
> Sent: Friday, May 05, 2000 3:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author:
> INET: LBhat_at_LEVI.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
Received on Fri May 12 2000 - 04:27:29 CDT