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