Monday, June 29, 2009

Recreate capture process

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;


No comments: