RE: rules for database link usage

We use dblinks a lot, and it work ok.
We usually create read-only users dedicated to the dblink. Indeed we have dblink toward SQLServer databases (using Oracle HS), and works ok too.  

You must take care when you restore the database in another server, we usually change tnsnames.ora file.  

When you create a dblink the SCN of both databases is synchronized, but there are no problems with this.  

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Jeff C Enviado el: lunes, 17 de febrero de 2014 16:48 Para: oracle-l_at_freelists.org
Asunto: rules for database link usage  

What are you rules for using database links in a production application? We currently have an application that needs data from another database and I am torn between having them just use a database link or copying the data to their database using various methods. I am leaning towards duplicating the data because I prefer to not have this database dependent on the other or one causing havoc on the other. But I guess if that didn't matter what in general are your rules?  

Jeff

--
http://www.freelists.org/webpage/oracle-l