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.  
 
CREATE PUBLIC DATABASE LINK ...;

  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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions