Home » Server Options » Streams & AQ » Granting capture rules script does not finish (10g, 10.2.0.3, OEL5)
Granting capture rules script does not finish [message #412832] Sun, 12 July 2009 22:15
v_zaitsev
Messages: 12
Registered: May 2009
Location: Manila
Junior Member
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. Sad
Previous Topic: streams and dataguard
Next Topic: Streams capture: waiting for archive log
Goto Forum:
  


Current Time: Fri Mar 29 07:05:09 CDT 2024