CREATE DATABASE LINK name_of_link CONNECT TO oracle_username IDENTIFIED BY password -- no quotes here USING 'database_sid' -- single quotes here / -- test select * from dual@name_of_link /
by simon baird
Friday, August 03, 2007
Oracle create database link example
The syntax for the create database link command is pretty much impossible to figure out. I always get it wrong. Even when I read the docs carefully. So here's my version of the example.