| |
 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 5 -
Apply Process Configuration
Using add_schema_rules to Create an
Apply process
For example, to create positive rule set and
associate with Apply process for the schema NY2, use the following
SQL statement. It creates a positive rule set and associates it with
the Apply process.
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name =>
'ny2',
streams_type => 'apply',
streams_name => 'ln2_apply',
queue_name => 'ln2_queue',
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
source_database => 'dnytst10.world',
inclusion_rule => true);
END;
/
The above example creates the following rules
and rule sets:
SELECT STREAMS_TYPE,
RULE_NAME, RULE_SET_NAME ,
RULE_SET_TYPE, STREAMS_RULE_TYPE,
SCHEMA_NAME, RULE_TYPE
FROM DBA_STREAMS_RULES where STREAMS_NAME='LN2_APPLY'
/
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
