ogg 清理 capture进程

SQL> select a.CAPTURE_NAME,a.STATUS,b.SERVER_NAME from dba_capture a,dba_xstream_outbound b where a.CAPTURE_NAME=b.CAPTURE_NAME and a.STATUS='DISABLED';

CAPTURE_NAME STATUS SERVER_NAME
------------------------------ -------- ------------------------------
OGG$CAP_E_SCOTT DISABLED OGG$E_SCOTT
OGG$CAP_E_TEST DISABLED OGG$E_TEST
OGG$CAP_E_LIONN DISABLED OGG$E_LIONN

此功能主要是清理ogg集成模式在oracle中的capture进程

SQL> exec dbms_apply_adm.drop_apply('OGG$E_SCOTT');
exec dbms_capture_adm.stop_capture('OGG$CAP_E_SCOTT');
exec dbms_capture_adm.drop_capture('OGG$CAP_E_SCOTT');
PL/SQL procedure successfully completed.

SQL> 
PL/SQL procedure successfully completed.

SQL> 

PL/SQL procedure successfully completed.