彻底删除stream

 

1捕获
select * from dba_capture;
exec dbms_capture_adm.stop_capture('CAPTURE_NAME');
exec dbms_capture_adm.drop_capture('CAPTURE_NAME');
2.传播
select * from dba_propagation;
exec dbms_propagation_adm.stop_propagation('PROPAGATION_NAME');
exec dbms_propagation_adm.drop_propagation('PROPAGATION_NAME');

3.应用
select * from dba_apply;
exec dbms_apply_adm.stop_apply('STREAMS_APPLY');
exec dbms_apply_adm.drop_apply('STREAMS_APPLY');

如果：
db - Streams
ORA-26663: error queue for apply process APPLY_STREAM must be empty
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 283
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 270
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 691
ORA-06512: at line 2

------------

option 1) Correct the cause of the errors and reapply changes using:
BEGIN
DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS(
    apply_name      => 'APPLY_NAME',
    execute_as_user => false);
END;

option 2) Brutally truncate the queue:
EXEC DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name => 'APPLY_NAME');

Finally you can remove the apply process:
BEGIN
DBMS_APPLY_ADM.DROP_APPLY(
    apply_name => 'APPLY_NAME');
END;

4队列：
exec dbms_aqadm.drop_queue('TEST1$APPQ');
exec dbms_aqadm.drop_queue_table('TEST1$APPQT');
5.移除配置
exec dbms_streams_adm.remove_streams_configuration;

http://hi.baidu.com/sevenqxy/blog/item/f8a527f3458c9458352accdd.html