CREATE DATABASE LINK

Create a Database Link.

Syntax:

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
     [CONNECT TO CURRENT_USER]
        [USING 'connect_string']

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
      [CONNECT TO user IDENTIFIED BY password]
      [AUTHENTICATED BY user IDENTIFIED BY password]
         [USING 'connect_string']

Periods are allowed within a link_name so a dblink called MY.LINK is valid.

If not already setup, ensure the database has a global name.
e.g.
ALTER DATABASE rename global_name to SS64.WORLD

Example

CREATE Public Database Link SS64
Connect To scott Identified By demo
Using test;

SELECT count(*) from table@ss64;

"During my service in the U.S. Congress, I took the initiative in creating the Internet" ~ Al Gore

Related Oracle Commands:

DROP DATABASE LINK
ALTER SESSION CLOSE DATABASE LINK link_name
DBMS_HS_PASSTHROUGH

Related Views:

DBA_DB_LINKS        ALL_DB_LINKS        USER_DB_LINKS

 
Copyright © 1999-2024 SS64.com
Some rights reserved