Executing Error Transactions

After you have resolved the problem that caused an error transaction, you can re-execute the error transaction. If the error transaction executes successfully, Oracle automatically removes the transaction from the replication catalog at the local site.

To re-execute an error transaction:

1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

2. Click Data Movement.

3. Under the Advanced Replication section, click Manage.

   The Administration Overview page appears.

4. Under the General section, click the number link next to Error Transactions to open the Error Transactions page.

5. Select the individual error transaction.

6. Click Retry.

When Oracle re-executes an error transaction at the receiving site, Oracle executes the transaction in the security context of the original receiver. If the original receiver is no longer a valid user (that is, if the user was dropped), the deferred transaction can be re-executed under the security context of a different user using the DBMS_ DEFER_SYS.EXECUTE_ERROR_AS_USER procedure.

For detailed information about this procedure, see Oracle Database Advanced Replication Management API Reference.