 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 5 -
Apply Process Configuration
Using add_subset_rules for Apply
Creation
PROMPT (4) Add SUBSET Rules and create the
APPLY Process
BEGIN
DBMS_STREAMS_ADM.ADD_SUBSET_RULES(
table_name => 'ny3.allinsured1',
dml_condition => ' SALES_ID > 100 ',
streams_type => 'apply',
streams_name => 'ln3_apply',
queue_name => 'ln3_queue',
include_tagged_lcr => false,
source_database => 'DNYTST10.world' );
END;
/
At the Source database, create propagation
rules and then instantiate the table manually:
Connect strmadm/strmadm@dnytst10
PROMPT (5) Create propagate rules for the table
AllInsured1
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name =>
'ny3.allinsured1',
streams_name => 'ny3_propagate',
source_queue_name =>
'strmadm.ny3_queue',
destination_queue_name
=> 'strmadm.ln3_queue@DNYOIP20.world',
include_dml => true,
include_ddl => true,
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
