CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password USING sqlnet_string;
SELECT * FROM tablename@linkname;
eg:
create database link ocum connect to zifar_cum identified by zifarcum using 'orcl'
CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password USING sqlnet_string;
SELECT * FROM tablename@linkname;
eg:
create database link ocum connect to zifar_cum identified by zifarcum using 'orcl'