Retrying or Deleting Apply Error Transactions

"Correcting Apply Errors in Database Objects" describes correcting the problem that caused one or more error transactions. After you correct the problem, you can retry the error transactions or delete them:

• Retry the transactions if the changes in the transaction should be made to the destination table. Retry them only if you have not already modified the data in the table to make these changes.

• Delete the transactions if you made all of the changes in the transactions to the destination table, or if the changes should not be made to the table.

To retry or delete apply error transactions: 

1. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Manage Replication in the Streams section.

   The Streams page appears, showing the Overview subpage.

5. Click Streams to open the Streams subpage.

   An apply error might cause an apply process to abort. When an apply process aborts, the status of the apply process is ABORTED.

6. Select the apply process with error transactions in the list of components. If necessary, use the search tool to find the apply process, and then select it.

7. Select View Errors in Action.

8. Click Go to open the Apply Errors page.

   You can view detailed information about an error by clicking the icon in the View Error LCRs field for the error transaction. The detailed information appears on the View Error LCRs page and includes each change in the transaction.

   To drill down further, select a row change and click Compare Values. The Compare Values page appears and compares the row change with the data in the table to which the change should be applied.

9. If you drilled down to more information about an error, then go back to the Apply Errors page by clicking the Apply Errors link.

10. On the Apply Errors page, complete one of the following actions:

    • To retry all error transactions, click Retry all Errors.

    • To delete all error transactions, click Delete All.

    • To retry a specific error transaction, select the error transaction and click Retry Error.

    • To delete a specific error transaction, select the error transaction and click Delete.