Hi ,

I have one doubt in Oracle Streams...see below comments

SQL> set echo on
SQL> spool add_rules.out
SQL> @c:\admin\streams\add_rules.sql
SQL> BEGIN
2 DBMS_STREAMS_ADM.ADD_TABLE_RULES(
3 table_name => 'rajesh.employe',
4 streams_type => 'capture',
5 streams_name => 'strm01_capture',
6 queue_name => 'rajesh.streams_queue',
7 include_dml => true,
8 include_ddl => true,
9 inclusion_rule => true);
10 END;
11 /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312
ORA-06512: at line 2

SQL>


So here what my doubt is ...What privileges the user should have to "Adding Rules to the Positive Rule Set for a Capture Process" ?

Can anybody help me?

Thanks
Rajesh