Remove the local Streams configuration

Connect as sysadmin on the source and capture site eg; HOMEDEV & ASMDB and execute the following.

SELECT propagation_name FROM dba_propagation; -- get propagation if existing

exec dbms_propagation_adm.drop_propagation('PROPAGATION$_61'); -- parameter value from query above.

exec dbms_streams_adm.remove_streams_configuration;

Related Posts:

Streams 10gR2 - How to

One-Way SCHEMA Level Streams Replication