有一些事情，是handler做不到的，需要自定义rule，像排除特定类型的DDL，特定种类的对象的DDL不捕获。这是时候需要自定义RULE

如何排除一种DDL操作

BEGIN

DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(

schema_name => 'HR',

streams_type => 'capture',

streams_name => 'strm01_capture',

queue_name => 'strmadmin.STREAMS_QUEUE',

include_dml => false,

include_ddl => true,

include_tagged_lcr => false,

source_database => 'SOURCE.IDC.ORACLE.COM',

inclusion_rule => FALSE, -- False means a negative ruleset is added.

and_condition => '(:ddl.get_command_type() = ''ALTER TABLE'')' -- quotes around ''ALTER TABLE''

);

END;

/

如何排除特定类型对象的操作

BEGIN

DBMS_RULE_ADM.ALTER_RULE (

rule_name => 'HR42',

condition => '(:ddl.get_object_owner() = ''HR'' and :ddl.is_null_tag() = ''Y'' and :ddl.get_object_type() != ''SYNONYM'') ',

evaluation_context => NULL);

END;

/