OraFAQ Forum: SQL & PL/SQL » Rollback a committed trans

Home » SQL & PL/SQL » SQL & PL/SQL » Rollback a committed trans

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rollback a committed trans [message #290782]

Mon, 31 December 2007 14:35

susuOra
Messages: 10
Registered: December 2007
Location: USA

Junior Member

Hey,
When there is a way to rollback a committed transition.

Thanks,
Susu

Report message to a moderator

Re: Rollback a committed trans [message #290783 is a reply to message #290782]

Mon, 31 December 2007 14:40

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: Rollback a committed trans [message #291048 is a reply to message #290782]

Wed, 02 January 2008 18:04

Kevin Meade
Messages: 2103
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.

Report message to a moderator

Previous Topic:	Instead of using Cursor is there any other option.
Next Topic:	Query regarding Exchange Partiiton

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 11:15:04 CDT 2024