Using add_schema_rules to Create an
Apply process
Streams Rule Rule Set Rule Set
Rule Schema Rule
Type Name Name Type
Level Name Type
------- ----- -------- --------
------- ------- ---
APPLY NY270 RULESET$_72 POSITIVE
SCHEMA NY2 DML
APPLY NY271 RULESET$_72 POSITIVE
SCHEMA NY2 DDL
The following SQL statements show the rule
conditions for the above mentioned rules:
SELECT
dbms_lob.substr(rule_condition,dbms_lob.getlength(rule_condition),1)
rule_condition FROM dba_rules where rule_name = 'NY270'
/
RULE_CONDITION
--------------------------------------------------|
((:dml.get_object_owner () = 'NY2') and
:dml.is_nul
l_tag() = 'Y' and
:dml.get_source_database_name ()
= 'DNYTST10.WORLD' )
SELECT
dbms_lob.substr(rule_condition,dbms_lob.getlength(rule_condition),1)
rule_condition
FROM dba_rules where rule_name = 'NY271'
/
