What is public database link

Showing Answers 1 - 2 of 2 Answers

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.  

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions