Topic : Database Link

What is database link?


Answer :

A database link is a named object that describes a ?path? from one database to another.

Show Answer Discuss

What are the types of database links?


  • "Private database link
  • public database link & network database link."

Answer :

"Private database link

Show Answer Discuss

What is private database link?


Answer :

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.

Show Answer Discuss

What is public database link?


Answer :

Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

Show Answer Discuss

What is network database link?


Answer :

Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

Show Answer Discuss