Skip to content
≡

Administrator

Developer

Tools

External Tools

ROLLBACK FORCE DATABASE LINK

The occurrence of a network failure on a global transaction can result in ROLLBACK failure of a transaction on a remote server. In such occasions, the ROLLBACK FORCE DATABASE LINK statement forces the available server to ROLLBACK the transaction, instead of processing the global transaction as a ROLLBACK failure.

When the DBLINK_GLOBAL_TRANSACTION_LEVEL property is set to '2' (two-phase commit), executing this statement is same as executing ROLLBACK.

Syntax#

ROLLBACK FORCE DATABASE LINK;

Example#

iSQL> ROLLBACk FORCE DATABASE LINK;