Friday, June 24, 2011

Stop and Suppress the Oracle Streams Configuration

In order to do it it, we'll need to stop and drop the capture & apply processes; we'll drop the Streams queue, the Streams administrator and the associated tablespace. 

connect / as sysdba

exec dbms_apply_adm.stop_apply('sync_apply');

exec dbms_capture_adm.drop_capture('sync_capture',true);

exec dbms_apply_adm.drop_apply('sync_apply',true);

exec dbms_streams_adm.remove_queue('strmadmin.streams_queue',true,true);

drop user strmadmin cascade;

drop tablespace streams_tbs
including contents and datafiles;

drop user destination cascade;
drop user source cascade;

No comments:

Post a Comment