Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 5 of 6
To undo work done in the current transaction, or to manually undo the work done by an in-doubt distributed transaction.
Note:
Oracle recommends that you explicitly end transactions in application programs using either a |
See Also:
|
To roll back your current transaction, no privileges are necessary.
To manually roll back an in-doubt distributed transaction that you originally committed, you must have the FORCE
TRANSACTION
system privilege. To manually roll back an in-doubt distributed transaction originally committed by another user, you must have the FORCE
ANY
TRANSACTION
system privilege.
|
is optional and is provided for ANSI compatibility. |
|
rolls back the current transaction to the specified savepoint. If you omit this clause, the |
|
Using |
|
Using
|
|
Restriction: You cannot manually roll back an in-doubt transaction to a savepoint. |
|
manually rolls back an in-doubt distributed transaction. The transaction is identified by the 'text' containing its local or global transaction ID. To find the IDs of such transactions, query the data dictionary view See Also: Oracle8i Distributed Database Systems for more information on distributed transactions and rolling back in-doubt transactions. |
|
A
Restriction: |
The following statement rolls back your entire current transaction:
ROLLBACK;
The following statement rolls back your current transaction to savepoint SP5:
ROLLBACK TO SAVEPOINT sp5;
The following statement manually rolls back an in-doubt distributed transaction:
ROLLBACK WORK FORCE '25.32.87';
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|