Oracle10g stream : :dml.get_command_type and lcr.get_command_type
Oracle10g 10.2.0.4 , RAC , Linux AS 5.3
being
DBMS_RULE_ADM.CREATE_RULE(
rule_name=>'fbtest_rule_x',
condition=>'(:dml.get_command_type() = ''INSERT''
OR :dml.get_command_type() = ''DELETE'')
AND :dml.get_object_owner() = ''RT01''
AND :dml.get_object_name() = ''ORDERPDO_ORDER'' ');
end;
/
begin
dbms_streams_adm.add_table_rules(
table_name =>'server7.bizdoc',
streams_type =>'capture',
streams_name =>'capture_prod',
queue_name =>'strmadmin.prod_queue',
include_dml =>true,
include_ddl =>true,
include_tagged_lcr =>false,
source_database =>null,
inclusion_rule =>true,
and_condition =>':lcr.get_command_type() in (''INSERT'',''UPDATE'')');
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-630428/ ，如需转载，请注明出处，否则将追究法律责任。
