Home » SQL & PL/SQL » SQL & PL/SQL » How to rollback a transaction which got commited
How to rollback a transaction which got commited [message #246260] Wed, 20 June 2007 08:05 Go to next message
donind
Messages: 95
Registered: February 2007
Member

How to roll back a transaction. which i commited mistakenly. Is there any way to roolback commited statement
Re: How to rollback a transaction which got commited [message #246262 is a reply to message #246260] Wed, 20 June 2007 08:06 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Nope.

You could always recover from the redo log, but other than that a commit is not reversible
Re: How to rollback a transaction which got commited [message #246265 is a reply to message #246260] Wed, 20 June 2007 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depending on your Oracle version, you may flashback your transaction.
You can also mine your logs using LogMiner to retrieve what have been done and undo it.

Regards
Michel
Re: How to rollback a transaction which got commited [message #246266 is a reply to message #246262] Wed, 20 June 2007 08:10 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you have access to FLASHBACK queries, you can get at the data from before it was committed, but you have to have been set up for them at the point where you had the problem.

You could always look into Logminer as well.

[Drat - too slow]

[Updated on: Wed, 20 June 2007 10:21]

Report message to a moderator

Re: How to rollback a transaction which got commited [message #246268 is a reply to message #246266] Wed, 20 June 2007 08:13 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Can u explain me the procedure of retriving transaction from flash back querries
Re: How to rollback a transaction which got commited [message #246278 is a reply to message #246268] Wed, 20 June 2007 08:38 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure your version supports it?

Regards
Michel
Previous Topic: How to get a postion of a character in string
Next Topic: Getting MAx value runtime
Goto Forum:
  


Current Time: Fri Dec 09 08:05:57 CST 2016

Total time taken to generate the page: 0.10563 seconds