| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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,5366965,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_at_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. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 20 2007 - 11:31:31 CDT
 |
 |