Database link types - Oracle Distributed Database concepts

Discussion

• Nirja Shah   -Posted on 21 Sep 15
  - Oracle Database lets you create private, public, and global database links.
  
  - These basic link types differ according to which users are allowed access to the remote database:
  
  - Private - Creates link in a specific schema of the local database. Only the owner of a private database link or PL/SQL subprograms in the schema can use this link to access database objects in the corresponding remote database.
  
  - Public - Creates a database-wide link.
  - All users and PL/SQL subprograms in the database can use the link to access database objects in the corresponding remote database.
  
  - Global - Creates a network-wide link.
  - When an Oracle network uses a directory server, the directory server automatically create and manages global database links (as net service names) for every Oracle Database in the network.
  - Users and PL/SQL subprograms in any database can use a global link to access objects in the corresponding remote database.

➨ Post your comment / Share knowledge