RE: Undelete Record

If you have access to Metalink, I suggest reviewing Note# 174425.1. It will show how this feature works in Oracle9i Release 1.

• Kirti

-----Original Message-----
Sent: Friday, December 20, 2002 7:54 PM
To: Multiple recipients of list ORACLE-L

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:kirti.deshpande_at_verizon.com]
> 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" <pgro_at_bgs.ac.uk> 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: kirti.deshpande_at_verizon.com

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: 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).