Oracle Database Discussions

Hi Experts,

I have a bi-direction strem for oracle 10G in 32 bit window.
I stop stream and drop capture, propagation at both site. I alse delete A site apply_process.
But I can not delete B site Apply process.
I use BEGIN
DBMS_APPLY_ADM.DROP_APPLY(
apply_name => 'STRMADMIN_APPLY',
drop_unused_rule_sets => true);
END;
/
or exec DBMS_APPLY_ADM.DROP_APPLY( 'STRMADMIN_APPLY');
or exec dbms_streams_adm.remove_streams_configuration();

I already use exec DBMS_APPLY_ADM.DELETE_ALL_ERRORS(); to delete all error before drop apply.
it takes over 7 hrs without any message or lock

So How can I can drop this apply process. I already strop this apply and sql show as
1* select apply_name, status from dba_apply
2 /

APPLY_NAME STATUS
------------------------------ --------
STRMADMIN_APPLY ABORTED

What do I need to do for drop apply?

Thanks for help!!

JIM

/

Edited by: user589812 on Mar 7, 2009 5:04 PM