Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: Streams Subset-Rule issue

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: ksarabu@xxxxxxxxx
Date: Fri, 20 Jul 2007 12:05:53 -0400

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@xxxxxxxxx> 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

Follow-Ups:

Re: Streams Subset-Rule issue
From: krishna sarabu

References:
- Streams Subset-Rule issue
  - From: krishna sarabu

Re: Streams Subset-Rule issue

Other related posts: