But by the way Kirti, would you like to give me a script what flashback
query looks like ? honestly I never use it.

Thanks - Sony

> -----Original Message-----
> From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, December 20, 2002 8:29 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: Undelete Record
> 
> If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly,
> then flashback query can be the answer...
> 
> - Kirti 
> 
> -----Original Message-----
> Sent: Friday, December 20, 2002 5:04 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> the audit table works well, I've used it before and am implementing it
> now (after the fact, the code base "updated" orders incorrectly, I was
> told "we don't want audit tables" beforehand, now they are desperate)
> 
> be careful with logminer, it's not intuitively obvious which statement
> is the one you want to recover and, if you do a lot of data refresh (we
> do a daily truncate and reload of a catalog schema) can give you LOTS
> of records to go through -- in our case, 11 million records in two days
> of logs
> 
> 
> --- "Robson, Peter" <[EMAIL PROTECTED]> wrote:
> > 
> > 
> > > 
> > > 
> > > Hi Listers,
> > > 
> > > I have little problem :
> > 
> > Hmmm, that may not be a little problem at all....
> > 
> > > how to undelete record that we've delete and commit so I can 
> > > restore again
> > > in my data, thanks a lot.
> > 
> > You can resort to conventional Oracle backup and recovery (other folk
> > will
> > tell you all about that).
> > 
> > But if you have important data tables, you can audit them
> > individually. We
> > have. We also have people who are liable to do just this sort of
> > thing.
> > Using our auditing approach, we can recover immediately, even after a
> > commit. Requires an audit table for each data table, with a
> > pre-change
> > trigger to capture each row before the DML statement.
> > 
> > More details if you wish (after Christmas - I'm off!)
> > 
> > peter
> > edinburgh
> > 
> > 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Deshpande, Kirti
>   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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  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).

Reply via email to