Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle CREATE DATABASE LINK Statement      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: CREATE DATABASE LINK

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...
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 261 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?