删除stream apply进程的步骤!

SQL> exec dbms_apply_adm.drop_apply('STREAMS_APPLY');
BEGIN dbms_apply_adm.drop_apply('STREAMS_APPLY'); END;

*
ERROR at line 1:
ORA-26663: error queue for apply process STREAMS_APPLY must be empty
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 283
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 270
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 691
ORA-06512: at line 1
SQL> select apply_name,ERROR_MESSAGE,ERROR_CREATION_TIME from dba_apply_error;

STREAMS_APPLY
ORA-01917: user or role 'ELLEN_RO_ROLE' does not exist
15-APR-09

STREAMS_APPLY
ORA-01435: user does not exist
30-JUN-09

STREAMS_APPLY
ORA-01917: user or role 'ELLEN_ROLE' does not exist
30-JUN-09

STREAMS_APPLY

ORA-01403: no data found
30-JUN-08

SQL> DBMS_APPLY_ADM.DELETE_ALL_ERRORS;
SP2-0734: unknown command beginning "DBMS_APPLY..." - rest of line ignored.
SQL> exec DBMS_APPLY_ADM.DELETE_ALL_ERRORS;

PL/SQL procedure successfully completed.

SQL> select apply_name,ERROR_MESSAGE,ERROR_CREATION_TIME from dba_apply_error;

no rows selected

SQL> SQL>  exec dbms_apply_adm.drop_apply('STREAMS_APPLY');

PL/SQL procedure successfully completed.