Removing Deferred Transactions

In some cases, you might know that a deferred transaction in the queue at your local site will cause an error at the destination site if pushed to the site. In such cases, it might be appropriate to delete the deferred transaction from the local queue to prevent an error.

To delete an individual deferred 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 Deferred Transactions to open the Deferred Transaction page.

   All deferred transactions for the selected destination are displayed. Displayed information includes Transaction ID, Destination, Start Time, and Number of Calls.

5. Select the deferred transactions that you want to delete.

   Press Shift to select a range of transactions or press Control to individually select multiple transactions.

6. Click Remove.