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.
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);
Review the steps here and see where you may have missed something: http://www.morganslibrary.org/reference/demos/streams_demo1.html
And if you don't need the complexity of Streams and its rulesets consider using Change Data Capture
it is far easier to set up.
Finally what do you see in these dynamic performance views?