Home » SQL & PL/SQL » SQL & PL/SQL » Rollback a committed trans
Rollback a committed trans [message #290782] Mon, 31 December 2007 14:35 Go to next message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Hey,
When there is a way to rollback a committed transition.

Thanks,
Susu
Re: Rollback a committed trans [message #290783 is a reply to message #290782] Mon, 31 December 2007 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is no way.
Commit means I'm sure that I don't want to roll back.
So when you commited you say you will never want to roll back.

That said, there are ways to recover.
It depends on your version, your environment (Oracle database/instance parameters), what you want to "uncommit".

Regards
Michel
Re: Rollback a committed trans [message #291048 is a reply to message #290782] Wed, 02 January 2008 18:04 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
However, there are alternatives to rollback. Try doing some reading one these concepts:

Oracle Flashback
Oracle Workspace Manager
Oracle Total Recall


http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
http://www.oracle.com/technology/products/database/workspace_manager/index.html
http://www.oracle.com/database/total-recall.html


These are advanced features and not for everyone. Indeed, each requires planning at a design level. They are best used as initial features of a data service implementation rather than add-ons after the fact. In any event, enjoy the reading.

These kinds of technologies show yet again why Oracle is KING all other databases are just toys.

Good luck, Kevin.
Previous Topic: Instead of using Cursor is there any other option.
Next Topic: Query regarding Exchange Partiiton
Goto Forum:
  


Current Time: Sat Dec 10 05:02:42 CST 2016

Total time taken to generate the page: 0.18666 seconds