Re: Streams Subset-Rule issue

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 20 Jul 2007 12:05:53 -0400
Message-ID: <49d668000707200905n4e3815ecjaaca69c423912011@mail.gmail.com>

Krishna,

can you show the full text of the rule?

Why you didn't use (DEPTNO = 10 OR (DEPTNO>=501 and DEPTNO <= 600)) ?

On 7/20/07, krishna sarabu <ksarabu_at_yahoo.com> wrote:
> Hi,
>
> We are trying to setup a subset rule on source table using 200+ in-list
> values and experiencing ORA-936 errors, not sure if it is a bug/restriction.
> Have checked Oracle docs and found no restriction on in-list values in
> subset rules. Below is the error message: (Please note that the
> source/destination databases are on 10.2.0.2 and we are planning to use
> dedicated capture process/queue for this table)
>

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 20 2007 - 11:05:53 CDT