Roll back an in-doubt transaction to a savepoint - Oracle Transaction

Discussion

• Nirja Shah   -Posted on 23 Sep 15
  - The above sentence is false.
  
  - The true statement is:
  
  You cannot roll back an in-doubt transaction to a savepoint
  
  - ROLLBACK statement - It is used to undo work done in the current transaction or to manually undo the work done by an in-doubt distributed transaction.
  
  - SAVEPOINT statement - It names and marks the current point in the processing of a transaction. With the ROLLBACK TO statement, savepoints undo parts of a transaction instead of the whole transaction.

➨ Post your comment / Share knowledge