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

Q.  You can roll back an in-doubt transaction to a savepoint?
- Published on 29 Jul 15

a. Yes
b. No

ANSWER: No
 

    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


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)