Skip to content
≡

Administrator

Developer

Tools

External Tools

COMMIT FORCE DATABASE LINK

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

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

Syntax#

COMMIT FORCE DATABASE LINK;

Example#

iSQL> COMMIT FORCE DATABASE LINK;