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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
