Rollback to commited Savepoint gives error

Once commit is executed, the update is made permanent. Savepoint A is lost after COMMIT has been executed, therefore you can’t roll back anymore to this Savepoint A. As so, the rollback attempt is failed.

Be careful, this is a guaranteed situation on the exam. This is a little tricky, because rollback may have been executed if no COMMIT statement used.

 

Leave a comment

Your email address will not be published. Required fields are marked *