Re: Oracle Streams Queues

From: Ujang Jaenudin <>
Date: Thu, 18 Sep 2008 09:32:44 +0700
Message-ID: <>


in streams there is "subset table rule" which match for your case

thanks and regards
ujang | oracle dba
jakarta |

On Wed, Sep 17, 2008 at 11:40 PM, Stalin <> wrote:

> All,
> Wondering if anyone could chime in with the experience in implementing
> streams. We have a table wherein each subset of data needs to be
> replicated to different databases for e.g rows of type x to database
> A and rows of type y to database B and so on. Question is should i
> have separate capture queue for each subset data on source database or
> one queue and deal with routing data to appropriate destination apply
> queues in propagation process. i don't want to do filtering or
> processing on the destination queues, as the databases would be busy
> processing other requests. Are there any performance issues of having
> many capture queues on source database?
> Thanks
> Stalin
Received on Wed Sep 17 2008 - 21:32:44 CDT

Original text of this message