select * from dba_queue_tables
BEGIN
dbms_capture_adm.drop_capture(capture_name => 'RSA_STREAMS_CAPTURE',
drop_unused_rule_sets => TRUE);
END;
BEGIN
dbms_streams_adm.add_schema_rules(queue_name => 'RSA_STREAMS_CAPTURE_Q',
streams_type => 'CAPTURE',
streams_name => 'RSA_STREAMS_CAPTURE',
schema_name => 'RSA_REP',
include_dml => TRUE,
include_ddl => FALSE,
include_tagged_lcr => TRUE,
inclusion_rule => TRUE);
END;
BEGIN
dbms_capture_adm.drop_capture(capture_name => 'RSA_STREAMS_CAPTURE',
drop_unused_rule_sets => TRUE);
END;
BEGIN
dbms_streams_adm.add_schema_rules(queue_name => 'RSA_STREAMS_CAPTURE_Q',
streams_type => 'CAPTURE',
streams_name => 'RSA_STREAMS_CAPTURE',
schema_name => 'RSA_REP',
include_dml => TRUE,
include_ddl => FALSE,
include_tagged_lcr => TRUE,
inclusion_rule => TRUE);
END;
No comments:
Post a Comment