Home » SQL & PL/SQL » SQL & PL/SQL » rollback after commit (Oracle 10g)
rollback after commit [message #580371] Sat, 23 March 2013 10:36 Go to next message
sss111ind
Messages: 480
Registered: April 2012
Location: India
Senior Member


Hi All,

How to rollback after commit.

Regards,
Nathan
Re: rollback after commit [message #580373 is a reply to message #580371] Sat, 23 March 2013 10:37 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
Senior Member
>How to rollback after commit.

How to make my goat fly?


Neither will ever happen!
Re: rollback after commit [message #580376 is a reply to message #580371] Sat, 23 March 2013 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just go back in the past.

Regards
Michel
Re: rollback after commit [message #580468 is a reply to message #580376] Mon, 25 March 2013 02:15 Go to previous messageGo to next message
sss111ind
Messages: 480
Registered: April 2012
Location: India
Senior Member

Hi All,

I found the solution by doing Flashback query.

Regards,
Nathan
Re: rollback after commit [message #580481 is a reply to message #580468] Mon, 25 March 2013 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not rollback after a commit, this goes back to the past.
You should post your actual problem instead of asking us how to implement a solution you think.

Regards
Michel
Re: rollback after commit [message #580488 is a reply to message #580481] Mon, 25 March 2013 06:52 Go to previous message
sss111ind
Messages: 480
Registered: April 2012
Location: India
Senior Member

Hi Michel,

Actually while testing with some data it got commited mistakenly,So it must be needed a flashback.
Sorry for the confusion I have created.

Regards,
Nathan
Previous Topic: creating a package
Next Topic: SQL Issue to generate report for shopping store.
Goto Forum:
  


Current Time: Wed Sep 17 14:40:55 CDT 2014

Total time taken to generate the page: 0.20600 seconds