Definition:
In Oracle PL/SQL, the CREATE DATABASE LINK statement creates a schema object in one database that enables you to access objects on another database.
(The other database does not have be an Oracle Database system, but if you intend to access non-Oracle systems you'll need to use Oracle Heterogeneous Services.)
Example Syntax:
CREATE [PUBLIC] DATABASE LINK <link_name>
CONNECT TO <user_name>
IDENTIFIED BY <password>
USING '<service_name>';
Example Usage:
CREATE DATABASE LINK test
CONNECT TO jim IDENTIFIED BY jim
USING 'test';
In the example above, user jim on the remote database defines a fixed-user database link named test to the jim schema on the local database.
Related Links:
Related Code Snippets:
- Create Database Link - A database link is a schema object in one database that enables you to acce...
