清理Oracle Streams配置   备份capture的信息 select * from dba_capture; 检查stream SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn) from dba_capture where capture_type='LOCAL'; 使用管理员用户登陆后删除Streams配置：   
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);                            /*目标端数据库 */
SQL>DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION;   再次检查stream SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn) from dba_capture where capture_type='LOCAL';   查询stream进程应为空，表明已删除成功 SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn) from dba_capture where capture_type='LOCAL';