What is Private Database Link ?

Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

Interview Candidate
Sep 5th, 2004
4
3657

Concepts and Architecture

Answer

Showing Answers 1 - 4 of 4 Answers

kailasTile
Profile Answers by kailasTile

Oct 14th, 2011

Private database link is created by a user in his schema. While creating the link, the keyword GLOBAL is not used. The syntax for creation is CREATE DATABASE LINK myPrivateDBLink connect to identified by using ;
Private DB links can not be used by other schema's.

Ravikumar

Oct 18th, 2011

database link is created by a user in his schema,it has 2 types

1.private database link
2.public database link /global

private database link is access the object in separate user

syntax:

create database link connect to username identified by password using 'db_name';