Hiren Vachhani

• Mar 14th, 2005

 

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

Ratan

• Mar 25th, 2005

 

Savepoints are the temporary bookmarks. it is possible to rollback up to the named savepoint.

Scott

• May 12th, 2005

 

By utilizing savepoints, you are able to rollback to a given point in your processing. An example of this would be: 
... 
COMMIT; 
 
INSERT 
UPDATE 
SAVEPOINT A 
 
DELETE 
UPDATE 
INSERT 
SAVEPOINT B 
 
INSERT 
INSERT 
DELETE 
SAVEPOINT C 
 
ROLLBACK TO SAVEPOINT B 
 
I only lost the two inserts and delete. Had I not placed savepoints in my processing and used a rollback, I would have lost my entire transaction back to the last good commit.