I am getting ora-24010 error in the target database where I am configuring the apply process, DB is 10.2.0.1 on RHEL, could you please let me know where am I making mistake? This is how I am doing.
SQL> conn strmadmin/strmadmin@db2
SQL> begin dbms_streams_adm.add_table_rules
2 ( table_name => 'scott.test',
3 streams_type => 'apply',
4 streams_name => 'apply_stream',
5 queue_name => 'strmadmin.streams_queue',
6 include_dml => true,
7 include_ddl => true,
8 source_database => 'DB1',
9 inclusion_rule => true);
The capture process and the propogation rule and scn instantiation on the source were executed fine withut issue, I am having problem in the apply process.Any helpful suggestion is appreciated.