This discussion is archived
2 Replies Latest reply: Feb 2, 2013 6:34 AM by User505978 - Oracle RSS

Need Help about---)))  Streams Synchronous Capture

User505978 - Oracle Newbie
Currently Being Moderated
hi guys,

im trying to configure Streams Synchronous Capture in my test platform between 2 databases. I'm following the oracle support notes in metalink ID 1109293.1

i dont get any errors but my stream is not working. My table on target database can not be replicated, i mean nothing is happening. I couldnt figure out how to find my mistake.


I have some ideas, for example
what is the source_database in the following script? Really i configured everything 2-3 times from zero but it is not helping.

BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name => 'HR.EMP',
streams_name => 'sync_prop',
source_queue_name => 'strmadmin.sync_cap_queue',
destination_queue_name => 'strmadmin.sync_apply_queue@target_link',
source_database => '?????',
queue_to_queue => TRUE);
END;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points