Rani Rathna

• Jul 9th, 2005

 

You can create a public database link for a database. All users and PL/SQL subprograms in the database can use a public database link to access data and database objects in the corresponding remote database.  
 
When many users require an access path to a remote Oracle database, an administrator can create a single public database link for all users in a database.  
 
CREATE PUBLIC DATABASE LINK ...;

Pooja Agrawal

• Nov 22nd, 2006

 

Database link is a schema object in one database to access objects in another database. When you create database link with Public clause, it is available for access to all the users, and if you omit this clause, then database link is privat and available only to you.