Hi there,
I have a 4-way streams replication environment. DB is 10.2 and platforms are Win Server 2003.
I noticed recently that updates to one DB was not going through, but ok to 2.
I attempted to stop and then start the propogation from the source DB with:

exec dbms_propagation_adm.stop_propagaion(propagation_name=>'SRCDB_TO_DESTDB');

but this procedure hangs.

Does anyone have any idea why this is?

Thanks.

>> Does anyone have any idea why this is?

It could be many things, you need to troubleshoot it! I would use the diagnostic checklists from the Oracle Streams book:

http://www.rampant-books.com/book_2004_2_streams.htm

Also, query the Oracle Streams views for clues:

http://www.dba-oracle.com/t_streams_monito...reams_views.htm

If you don't want to write the scripts yourself, you can download them from the Oracle script collection:

http://www.oracle-script.com/