I used triggers on the tables.. inserted the original row plus
type_code plus user plus timestamp on the change for a delete, the new
row etc etc for an insert and both before and after rows for an update
- "Robson, Peter" <[EMAIL PROTECTED]> wrote:
> Ditto.
>
> We capture the rowid of every row subject to a transaction,
> identifying
> table name and transaction type (update, insert, delete). Saved us
> immense
> time when things really go awol.
>
> peter
> edinburgh
>
> (its called auditing!)
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> > Sent: 24 June 2003 20:59
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: log for transaction
> >
> >
> > We use a similiar method which involves inserting periodic
> > rows into a log
> > table, which is dumped to a file at end-of-job.
> >
> > Scott Shafer
> > San Antonio, TX
> > 210.581.6217
> >
> >
> > > -----Original Message-----
> > > From: Kirtikumar Deshpande
> > [SMTP:[EMAIL PROTECTED]
> > > Sent: Tuesday, June 24, 2003 2:05 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: log for transaction
> > >
> > > Oracle does not have any ready-made logging process to assist
> you.
> > > Some of our developers have utilized 'utl_file' to track
> > the progress of
> > > their long running jobs.
> > > Entries are made to the job log file at proper intervals to
> > tell them what
> > > happened in case the
> > > job aborted.
> > >
> > > - Kirti
> > >
> > > --- [EMAIL PROTECTED] wrote:
> > > > Hi there,
> > > >
> > > > I got a question on log. If my program crashes, can I
> > check some log to
> > > see what
> > > > recent transaction is? It will give me a big help on
> > trouble shooting.
> > > >
> > > > Thanks,
> > > > Jin
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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).
> >
>
>
> *********************************************************************
> This e-mail message, and any files transmitted with it, are
> confidential and intended solely for the use of the addressee. If
> this message was not addressed to you, you have received it in error
> and any copying, distribution or other use of any part of it is
> strictly prohibited. Any views or opinions presented are solely those
> of the sender and do not necessarily represent those of the British
> Geological Survey. The security of e-mail communication cannot be
> guaranteed and the BGS accepts no liability for claims arising as a
> result of the use of this medium to transmit messages from or to the
> BGS. . http://www.bgs.ac.uk
> *********************************************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Robson, Peter
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
Received on Wed Jun 25 2003 - 11:35:31 CDT
