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.
标签：capture,dbms,CAP,清理,EMP,SQL,ogg,OGG From： https://www.cnblogs.com/dbahrz/p/17897030.html