The Flashback Transaction Wizard works as follows:
If the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure with the NOCASCADE option fails (because there are dependent transactions), you can change the recovery options.
With the Nonconflict Only option, nonconflicting rows within a transaction are backed out, which implies that database consistency is maintained (although the transaction atomicity is broken for the sake of data repair).
If you want to forcibly back out the given transactions, without paying attention to the dependent transactions, use the Nocascade Force option. The server simply executes the compensating DML commands for the given transactions in reverse order of their commit times. If no constraints break, you can proceed to commit the changes, or else roll back.
To initiate the complete removal of the given transactions and all their dependents in a post-order fashion, use the Cascade option.
Note: This screenshot is not part of the workflow example, but shows additional details of a more complex situation.
The Flashback Transaction Wizard works as follows:
If the DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure with the NOCASCADE option fails (because there are dependent transactions), you can change the recovery options.
With the Nonconflict Only option, nonconflicting rows within a transaction are backed out, which implies that database consistency is maintained (although the transaction atomicity is broken for the sake of data repair).
If you want to forcibly back out the given transactions, without paying attention to the dependent transactions, use the Nocascade Force option. The server simply executes the compensating DML commands for the given transactions in reverse order of their commit times. If no constraints break, you can proceed to commit the changes, or else roll back.
To initiate the complete removal of the given transactions and all their dependents in a post-order fashion, use the Cascade option.
Note: This screenshot is not part of the workflow example, but shows additional details of a more complex situation.
การแปล กรุณารอสักครู่..