Streams Configuration Removal scripts

Disable propagation schedule
EXEC dbms_aqadm.disable_propagation_schedule(
queue_name =>; ‘capture name’,
destination =>; ‘destination’,
destination_queue =>; ‘apply name’);
Drop propagation
EXEC dbms_propagation_adm.drop_propagation(
propagation_name =>; ‘propagation name’,
drop_unused_rule_sets =>; TRUE);
Remove Streams
EXEC dbms_streams_adm.remove_streams_configuration;
Drop Queues for capture and apply
  • drop capture queue
EXEC DBMS_STREAMS_ADM.REMOVE_QUEUE(‘’,TRUE);
  • drop apply queue
EXEC DBMS_STREAMS_ADM.REMOVE_QUEUE(‘’,TRUE);
  • Drop streams user
DROP USER strmadmin cascade;
Tagged with →  
Share →
0 comments
Skip to toolbar