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