Oracle Streams配置起来很久了，由于一些原因没有正式使用，需要完全清理掉它的配置信息。Streams主要有三个部分组成，capture,progapation,apply，还有一些基础配置信息。
删除掉这些配置信息，就完全清理干净streams了。
首先停止并删除capture进程
SQL> select capture_name,status from dba_capture;
CAPTURE_NAME STATUS
------------------------------ --------
STRMADMIN_CAPTURE DISABLED
SQL> exec dbms_capture_adm.stop_capture('STRMADMIN_CAPTURE');
PL/SQL procedure successfully completed.
SQL> exec dbms_capture_adm.drop_capture('STRMADMIN_CAPTURE');
PL/SQL procedure successfully completed.
停止并删除propagation进程
SQL> select propagation_name,status from dba_propagation;
PROPAGATION_NAME STATUS
------------------------------ --------
STRMADMIN_PROPAGATE DISABLED
SQL> exec dbms_propagation_adm.drop_propagation('STRMADMIN_PROPAGATE');
PL/SQL procedure successfully completed.
停止并删除apply进程
SQL> select apply_name,status from dba_apply;
no rows selected
清除整个streams配置
SQL> exec dbms_streams_adm.remove_streams_configuration;
PL/SQL procedure successfully completed.
数据库的初始化参数streams_pool_size 也可降低一下。