Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 25, 2013 1:09 AM by
Oracle streams and Global name
Oct 21, 2012 11:07 PM
I am new Oracle streams and is trying to replicate a few tables that are located in a different database in a different server.
Oracle docs says that Global name has to be set to true for streams.
Unfortunately we have legacy systems where the dblink names are not the same as the database and so I cannot set the Global name to true as it will cause the dblinks to fail.
Have anybody tried to do replication without the global names set to true? or is there a workaround?
the databases are both 11g.
Thanks for any suggestions
This content has been marked as final.
Show 1 reply
Re: Oracle streams and Global name
Apr 25, 2013 1:09 AM
in response to
It is recommended to set global_names to true for streams. But streams will work fine even if global_names is set to false.
Just make sure that your dblink is working fine.