Re: How to recover previous rows after update

From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 6 Dec 2011 14:42:21 -0800 (PST)
Message-ID: <9378f391-1de3-419c-ae00-c3223bd313c1_at_c18g2000yqj.googlegroups.com>

On Dec 6, 5:31 am, mhoys <matthias.h..._at_gmail.com> wrote:
> On Dec 3, 6:37 am, Anupam Kumar <haker.z..._at_gmail.com> wrote:
>
> > Hi,
> > One user has accidentally upadated  and commited the transaction. Now
> > my job is to restore the previous data for that table. Is there any
> > way to do it. Its already been 24 hr past when It happen.. I'm not
> > sure wether I can use Flashback or not.
>
> > Pease help.
>
> > Thanks in advance,
> > Anupam
>
> Did you try to query the flashback data for the specific table to see
> if it returns any rows?
>
> select * from <table>
> as of timestamp to_timestamp('2011-12-01 11:00:00','YYYY-MM-DD
> HH:MI:SS')
>
> Matthias

First, fire the user, then Restore the backup to another system and recover the missing row. or if you have an export, restore the table to a new name (see impdp remap_schema, remap_table and recover it that way. Received on Tue Dec 06 2011 - 16:42:21 CST