Re: Oracle Streams Queues

stalinks,

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

-- 
thanks and regards
ujang | oracle dba
jakarta | http://ora62.wordpress.com

On Wed, Sep 17, 2008 at 11:40 PM, Stalin <stalinsk_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l