Hiiiiiiii,u follow below syntex
CREATE PUBLIC DATABASE LINK ABC CONNECT TO RAI IDENTIFIED BY ORACLE
USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 132.130.100.32)(port = 1521)))(connect_data =(sid = ORCL)))';
I hope it helps for you




Reply With Quote