Force any transaction privilege required for manually committing an in-doubt transaction

Q.  What is the correct privilege which is required for manually committing an in-doubt transaction?
- Published on 29 Jul 15

a. System privilege
b. Force any transaction
c. Both a & b
d. None of the above

ANSWER: Force any transaction


  • Nirja Shah   -Posted on 23 Sep 15
    - Use the COMMIT or ROLLBACK statement with the FORCE option and a text string that indicates either the local or global transaction ID of the in-doubt transaction to commit.

    - Before attempting to roll back the in-doubt distributed transaction, ensure that you have the proper privileges.

    - Note the following requirements:
    User Committing the Transaction --- Privilege Required
    Another user ---- FORCE ANY TRANSACTION

    - The following SQL statement rolls back an in-doubt transaction:

    ROLLBACK FORCE 'transaction_id';

    - The variable transaction_id is the identifier of the transaction as specified in either the LOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view.

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.)