posted 19 years ago
Hi there.
I'm new to DB and have a quastion.
How actually DB2 or Oracle works when you run a transaction which contains
for example 10 updates?
which one is correct?
1- copies the rows going to be updated to a temp space -->
writes the updates directly to the main table -->
if Commit happens -- > it's OK! and forgets the temp space
if Rollback happens --> rewrites the temp space to the original table
2- inserts the updates to a temp space -->
if Commit happens --> replaces the old rows in the table with new ones
if Rollback happens --> nothing going to do with the original table and forgets about the temp space
could anyone please describe it with a refrence from IBM or Oracle
Thank you in advance.
"The greatest pleasure in life is doing what people say you cannot do." --Walter Bagehot<p>SCJP 1.4<br />SCWCD 1.3</p>