Re: How to recover previous rows after update

From: mhoys <matthias.hoys_at_gmail.com>
Date: Tue, 6 Dec 2011 02:31:00 -0800 (PST)
Message-ID: <d80748c0-daf1-4ad8-9d8d-b8821a478979_at_y7g2000vbe.googlegroups.com>

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 Received on Tue Dec 06 2011 - 04:31:00 CST