Re: is it possible to undo one of the last transactions?

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 5 Apr 2006 10:47:38 -0700
Message-ID: <1144259258.216762.74200@u72g2000cwu.googlegroups.com>

Le,

As you are a newbie, start with the Oracle Concepts Manual, available at
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm. You will need to focus on the parts about transactions, data integrity/consistency, commits and rollbacks.

One of the foundations of Oracle is that a transaction is processed in total. You cannot rollback/undo part of a transaction while leaving a subsequent part intact. If you have 10 steps to an operational transaction, you might have to design the database component to be 10 separate transactions. This would enable you to decide which 'transactions' to commit and which to 'rollback'.

It is very, very important to think about what can happen if only part of the transaction is committed.

Regards,
Daniel Fink Received on Wed Apr 05 2006 - 12:47:38 CDT