Hi guys,
I successfully setup my streams at my destination DB however I had a problem setting up capture rules in streams for my source DB. Below is a script to add capture rules for my oracle streams set-up.
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name => 'ZABIN',
streams_type => 'CAPTURE',
streams_name => 'STREAM_CAPTURE_CIS',
queue_name => 'STRMADMIN.STREAMS_QUEUE_CIS',
include_dml => true,
include_ddl => true,
source_database => 'NMS01');
END;
/
This script ran for 2 days but it did not finish at all. I had to terminate the session for it to end. I've been doing this over and over again but it still does not finish. Is there a way to check whats happening with this script? Or is there a work around in this? Or is there something wrong with this script? I've checked naming conventions with my queue name, streams admin, and queue table and I can see nothing wrong with them. Please help.