配置streams时在删除进程出错ora-26663:sqlgt; exec dbms_apply_adm.drop_apply(
配置streams时在删除进程出错ora-26663:
sql> exec dbms_apply_adm.drop_apply('target_apply_stream');
begin dbms_apply_adm.drop_apply('target_apply_stream'); end;
*
error at line 1:
ora-26663: error queue for apply process ora-26663: error queue for apply
process target_apply_stream must be empty
must be empty
ora-06512: at sys.dbms_apply_adm_internal, line 359
ora-06512: at sys.dbms_apply_adm_internal, line 334
ora-06512: at sys.dbms_apply_adm, line 690
ora-06512: at line 1
这些需要删除表中的错误信息：
select * from dba_apply_error
exec dbms_apply_adm.delete_all_errors(apply_name=>'target_apply_stream')
再次执行可以
 exec dbms_apply_adm.drop_apply('target_apply_stream');
删除配置的进程如下:
select capture_name from dba_capture
exec dbms_capture_adm.drop_capture('capture_stream')
select propagation_name from dba_propagation
exec dbms_propagation_adm.drop_propagation('source_to_target')
select apply_name from dba_apply
exec dbms_apply_adm.drop_apply('target_apply_stream')
清除整个streams配置:(这会删除整个数据库中的streams配置，如果有两个streams的用户，会把这两个用户的进程删清楚掉)
exec dbms_streams_adm.remove_streams_configuration;
，