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