GeekInterview.com
Series: Subject: Topic:
Question: 223 of 252

What is public database link

Asked by: Interview Candidate | Asked on: Jul 9th, 2005
Showing Answers 1 - 2 of 2 Answers
Rani Rathna

Answered On : 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 ...;

  
Login to rate this answer.
Pooja Agrawal

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.