Home » SQL & PL/SQL » SQL & PL/SQL » Flashback update statement (Oracle 10.2.2.0,Windows)
Flashback update statement [message #379614] Wed, 07 January 2009 06:13 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hi all,

I updated a query few days ago say on 3rd january .later i realised that i should not have updated that query and now i want to flashback that updated statement. But i am not sure about the time and the ip address of the machine from where i fired that query.

Below is the query which i updated.

"update table set ename=mike where ename=juzz"

Is it possible to flashback the above updated query? if yes,how?

Please revert me with the answer.

Thanks in advance


With Regards,
Balaji

[Updated on: Wed, 07 January 2009 06:27]

Report message to a moderator

Re: Flashback update statement [message #379618 is a reply to message #379614] Wed, 07 January 2009 06:31 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Check the value of db_flashback_retention_target init parameter.

HTH.
Re: Flashback update statement [message #379619 is a reply to message #379614] Wed, 07 January 2009 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Log Miner.

Regards
Michel
Re: Flashback update statement [message #379620 is a reply to message #379618] Wed, 07 January 2009 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
michael_bialik wrote on Wed, 07 January 2009 13:31
Check the value of db_flashback_retention_target init parameter.

HTH.


db_flashback_retention_target is for flashing back the database not data of a single table.

Regards
Michel
Re: Flashback update statement [message #379661 is a reply to message #379620] Wed, 07 January 2009 09:26 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

I think enabling auditing is also possible to solve my above issue.

Thanks for the help.

Regards,
Balaji
Re: Flashback update statement [message #379695 is a reply to message #379661] Wed, 07 January 2009 12:46 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Auditing will not help.
Re: Flashback update statement [message #379765 is a reply to message #379614] Wed, 07 January 2009 21:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It may be possible with flashback query or flashback table depending on your undo_retention.
Re: Flashback update statement [message #379809 is a reply to message #379765] Thu, 08 January 2009 00:40 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
4 days of retention is very rare. Wink

Regards
Michel
Previous Topic: need help data getting committed without commit statement in procedure
Next Topic: Exception Handling
Goto Forum:
  


Current Time: Sun Dec 11 02:07:31 CST 2016

Total time taken to generate the page: 0.08934 seconds