Creating - Oracle DB Links

1. Log into the db from which the query will be executed.
2.create public database link using
ex Create Database link db1_link using db1_machine1
3. Database link is created

Common Problems
===============
1. When global_names parameter set to TRUE then default domain name 'REGRESS.RDBMS.DEV.US.ORACLE.COM' is appended at the end of the dblink name and will cause ORA-02805 error.


Changing global names
================
Alter system set Global_names =false;