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!

How can I delete UNDELIVERABLE queue entries?

95902Feb 4 2005 — edited Feb 11 2005

Due to a missing tnsnames.ora entry, we have entries in a queue table that are marked with a status of UNDELIVERABLE. I need to remove these entries!

I have tried dequeuing them, but Oracle responds that no entries exist.

I'm new to queuing, but I think the entries are not moving to the exception queue because they were not queued with an expire time.

I have searched this forum, MetaLink and asktom but have yet to find out how to do this. I also have a "stagnant" TAR open with Oracle support.

Any assistance will be greatly appreciated!!

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2005

Added on Feb 4 2005

#advanced-queueing, #database-key-features

1 comment

612 views