ogg 清理 capture进程-526互联

SQL> select server_name, capture_name from dba_xstream_outbound ;

SERVER_NAME                    CAPTURE_NAME
------------------------------ ------------------------------
OGG$E_EMP                      OGG$CAP_E_EMP

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

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

SQL> 
PL/SQL procedure successfully completed.

SQL> 

PL/SQL procedure successfully completed.

进程