清除stream:
源端:
exec dbms_streams_adm.remove_queue(queue_name=>'SOURCE_QUEUE',cascade=>true,drop_unused_queue_table=>true);
目标端:
exec dbms_apply_adm.stop_apply(apply_name=>'target_apply_stream');
exec dbms_apply_adm.delete_all_errors(apply_name=>'target_apply_stream');
exec dbms_apply_adm.drop_apply(apply_name=>'target_apply_stream');
exec dbms_streams_adm.remove_queue(queue_name=>'TARGET_QUEUE',cascade=>true,drop_unused_queue_table=>true);