Dear all

I have create a local database and i need to link it with another database in a host server , how can i do that ?

thanks in advance

sqlplus user /passwoer@LOCALDB
CREATE DATABASE LINK HDB CONNECT TO Hostdbsuer IDENTIFIED BY password using 'HOSTDB';

test dblink by :

desc emp@HDB ;

add an entry to tnsnames.ora file for the new database and then create the database link