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 http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/ds_admin002.htm

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: