René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Create database link in Oracle

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.