Muhammad Nadeem Chaudhry's Blog

Creating Oracle Database Link

Posted in Uncategorized by Muhammad Nadeem Chaudhry on July 11, 2011

create [public] database link db_link_name
connect to      user_name
identified by   password
using              Service_name

service_name must be resolvable on the server, for example by entering it into the tnsnames.ora file. A database link is required for various purposes, such as primary key materialized view replication.  This will create one sided link as specified in clause.

For further inform please visit

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: