web analytics

Understanding Database Link in Oracle

Options

codeling 1602 - 6666
@2017-04-03 14:20:33

A database link is a schema object in one database that enables you to access objects on another database.The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.

After you have created a database link, you can use it to refer to tables and views on the other database. In SQL statements, you can refer to a table or view on the other database by appending @dblink to the table or view name. You can query a table or view on the other database with the SELECT statement. You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement.

@2017-04-03 14:27:06

To create a private database link, you must have the CREATE DATABASE LINK system privilege. To create a public database link, you must have the CREATE PUBLIC DATABASE LINK system privilege. Also, you must have the CREATE SESSION system privilege on the remote Oracle database.

create_database_link::=

Description of create_database_link.gif follows
 

dblink_authentication ::=

Description of dblink_authentication.gif follows

 

USING 'connect string'

Specify the service name of a remote database. If you specify only the database name, then Oracle Database implicitly appends the database domain to the connect string to create a complete service name. Therefore, if the database domain of the remote database is different from that of the current database, then you must specify the complete service name.

The following statement defines a shared public database link named remote that refers to the database specified by the service name remote:

CREATE PUBLIC DATABASE LINK remote USING 'remote';

Comments

You must Sign In to comment on this topic.


© 2024 Digcode.com