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@(protected):
> 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