Dblink
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Dblink as PDF for free.
More details
- Words: 469
- Pages: 1
What is private database link
You can create a private database link in a specific schema of a database. Only the owner of a private database link or PL/SQL subprograms in the schema can use a private database link to access data and database objects in the corresponding remote database. A private database link is more secure than a public or global link because only the owner of the private link or subprograms within the same schema can use the private link to access the specified remote database. To create a private database link you specify: CREATE DATABASE LINK ...;
What are the types of database links ? Oracle allows you to create private public and global database links. Private Database Link: You can create a private database link in a specific schema of a database. Only the owner of a private database link or PL/SQL subprograms in the schema can use a private database link to access data and database objects in the corresponding remote database. Public Database Link : 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. Global Database Link - When an Oracle network uses Oracle Names the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprograms in any database can use a global database link to access data and database objects in the corresponding remote database. A private database link is more secure than a public or global link because only the owner of the private link or subprograms within the same schema can use the private link to access the specified 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. When an Oracle network uses Oracle Names an administrator can conveniently manage global database links for all databases in the system. Database link management is centralized and simple. What is public database link ?
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.
What is netwo rk data base link ? When an Oracle network uses Oracle Names the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprograms in any database can use a global database link to access data and database objects in the corresponding remote database.
You can create a private database link in a specific schema of a database. Only the owner of a private database link or PL/SQL subprograms in the schema can use a private database link to access data and database objects in the corresponding remote database. A private database link is more secure than a public or global link because only the owner of the private link or subprograms within the same schema can use the private link to access the specified remote database. To create a private database link you specify: CREATE DATABASE LINK ...;
What are the types of database links ? Oracle allows you to create private public and global database links. Private Database Link: You can create a private database link in a specific schema of a database. Only the owner of a private database link or PL/SQL subprograms in the schema can use a private database link to access data and database objects in the corresponding remote database. Public Database Link : 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. Global Database Link - When an Oracle network uses Oracle Names the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprograms in any database can use a global database link to access data and database objects in the corresponding remote database. A private database link is more secure than a public or global link because only the owner of the private link or subprograms within the same schema can use the private link to access the specified 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. When an Oracle network uses Oracle Names an administrator can conveniently manage global database links for all databases in the system. Database link management is centralized and simple. What is public database link ?
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.
What is netwo rk data base link ? When an Oracle network uses Oracle Names the names servers in the system automatically create and manage global database links for every Oracle database in the network. All users and PL/SQL subprograms in any database can use a global database link to access data and database objects in the corresponding remote database.
