Remove propagation Recebiver
edited Nov 13, 2011 11:19PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
Hi,
I have a propagation receiver in table v$propagation_receiver that is not been used. I guess that streams configuration has left some dirty in Oracle Catalog.
How can i clean v$propagation_receiver? Even with propagation , apply and capture stopped, there is a register in this table
SQL> Select SRC_QUEUE_SCHEMA , SRC_QUEUE_NAME , SRC_DBNAME from v$propagation_receiver@wattspp;
SRC_QUEUE_SCHEMA SRC_QUEUE_NAME SRC_DBNAME
------------------------------ ------------------------------ --------------------------------------------------------------------------------
STRMADMIN Q_WATTS_MX HWTMX01
When i start propagation, i have another propagation receiver with the same name
Regards
I have a propagation receiver in table v$propagation_receiver that is not been used. I guess that streams configuration has left some dirty in Oracle Catalog.
How can i clean v$propagation_receiver? Even with propagation , apply and capture stopped, there is a register in this table
SQL> Select SRC_QUEUE_SCHEMA , SRC_QUEUE_NAME , SRC_DBNAME from v$propagation_receiver@wattspp;
SRC_QUEUE_SCHEMA SRC_QUEUE_NAME SRC_DBNAME
------------------------------ ------------------------------ --------------------------------------------------------------------------------
STRMADMIN Q_WATTS_MX HWTMX01
When i start propagation, i have another propagation receiver with the same name
Regards
0