Re: Streams Subset-Rule issue

Thanks Alex.

Please see below for the actual subset rule call... Unfortunately the requirement is to use the random values list and we can't simplify it.. That sample call was just prepared to reproduce the issue..

BEGIN
DBMS_STREAMS_ADM.ADD_SUBSET_RULES(
    table_name               => 'strms_test.nts_derivative_ts',
    dml_condition            => 'AGI_ID IN (8700,8720,8750,8760,8770,8780,8790,8800,8810,8820,8830,8840,8850,8860,8870,8930,8940,
8950,8960,8970,9010,9020,9050,9070,9080,9090,9100,9110,9120,9130,9140,9150,9160,9170,9180,
9190,9200,9210,9220,9230,9240,9250,9260,9280,9290,9300,9340,9380,9390,9400,9410,9420,9430,
9440,9450,9460,9470,9490,9550,9580,9590,9610,9640,9650,9660,9720,9820,9830,9850,9860,9870,
9880,9900,9920,9930,9940,9950,9970,9980,9990,10010,10020,10030,10050,10070,10080,10090,10100,
10110,10120,10140,10150,10170,10180,10190,10200,10210,10220,10230,10260,10270,10280,10320,
10330,10340,10350,10360,11210,11290,11300,12420,3340373,3340401,3340426,4000285,4000286,4000289,
4000291,4000297,4000298,4000301,4000307,4000308,4000314,4000315,4000316,4000317,4000321,4000322,
4000323,4000324,4000325,4000326,4000327,4000328,4000362,4000389,4669501,4669568,4669569,4669570,
4669571,4669581,5345135,5356001,5356002,5356003,5358715,5358756,536696 5,5396063,5401435,5418021,
5426337,5450297,5455797,5507811,5507818,5513940,5513941,5513948,5513949,5513950,5543011,5543022,
5571228,5604007,5609411,5622904,5628516,5657811,5658706,5658713,5692808,5703815,5709007,5717009,
5724402,5724403,5768724,5769004,5791708,5796308,5812908,5818911,5833308,5843121,5854507,5865835,
5865840,5404303,5409751,5422276,5836523,5893256,5893261,5893277,5920622,5958209,6009008,6009010,
6180007,3060,2960,2980,6240,3340404,3050,5344188,5376523,5727004,5727054,5743007,5774647,5355994,
5366626,5372551,5376503,5376523,5381770,5384792,5408848,5648405,5698602,5700316)',
    streams_type             => 'CAPTURE',
    streams_name             => 'STST_CAPT01',
    queue_name               => 'STRMADMIN.CNRTS1_Q');
END;
/

24 BEGIN
*
ERROR at line 1:
ORA-25448: rule STRMADMIN.NTS_DERIVATIVE_TS123 has errors
ORA-00936: missing expression
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 49
ORA-06512: at "SYS.DBMS_RULE_ADM", line 178
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1205
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1073
ORA-06512: at line 2

Regards,
Krishna

Alexander Fatkulin <afatkulin@gmail.com> wrote:

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

Got a little couch potato?
Check out fun summer activities for kids.

Re: Streams Subset-Rule issue

krishna sarabu

2007-07-20