Save changes (transactional).
COMMIT [WORK] [COMMENT 'comment_text'] COMMIT [WORK] [FORCE 'force_text' [,int] ]
FORCE - will manually commit an in-doubt distributed
force_text - transaction identifier (see the DBA_2PC_PENDING view)
int - sets a specific SCN
If a network or machine failure prevents a distributed transaction from committing properly, Oracle will store any commit comment in the data dictionary along with the transaction ID.
Commit comments will be deprecated in a future version of Oracle.
Oracle strongly recommends that you use transaction names: SET TRANSACTION … NAME
“The difference between eggs and bacon: the chicken is involved, the pig is committed” - Anon
SAVEPOINT - Save changes to a point
ROLLBACK - undo changes
DBA_2PC_PENDING V$TRANSACTION V$TRANSACTION_ENQUEUE
© Copyright SS64.com 1999-2013
Some rights reserved