Streams Configuration Removal scripts
Disable propagation schedule
EXEC dbms_aqadm.disable_propagation_schedule(
queue_name =>; ‘capture name’,
destination =>; ‘destination’,
destination_queue =>; ‘apply name’);
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);
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;
