Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate queue table
"Mike" <mbrugo_at_despammed.com> wrote in message news:at26svoh5volt1ppoaajs5go5o2bmoqtsi_at_4ax.com...
> A simple question.
>
> After a message has been replicated from 2 queues (enqueued and
> dequeued succesfully), is there a mechanism to delete queue table ?
>
> i don't want my table grows too much.
>
>
> Mike
>
Set up a regular purge job. Its there in the replication api guide.
If a sudden batch activity causes the queue tables to become very big, then you might want to trucate the queue tables. The directions to truncate might differ in different versions (and guess what you have not supplied?) Look in metalink Note: 190885.1
Maybe a regularly scheduled purge job is all that you require.
Anurag Received on Tue Nov 25 2003 - 07:04:04 CST