Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_apply_adm.delete_all_errors call hangs

707685Feb 5 2011 — edited Feb 7 2011

I'm running 11.1.07 on Solaris 10. I have streams configured between several systems. There was an error in one of my apply handlers, and so - I got 10 rows that show up in dba_apply_error. I am unable to remove the errors - I tried "delete_all_errors" but it just sat there for an hour. I tried to use "delete_error(<local_trans_id>), but that doesn't work either. And "execute_all_errors" doesn't do the job.

The only way that I've found to get around the problem, is to follow the steps in Note 203225.1: How to manually clean up AQ Tables", but I hate having to do the "scorched earth" method to get rid of a couple errors.

I have an SR open, but they haven't answered the question of how to delete the errors.

Any help will be appreciated.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2011

Added on Feb 5 2011

#performance-availability, #streams

4 comments

820 views