how to create database link [message #16249] |
Thu, 18 November 2004 10:46 |
bikash karan
Messages: 24 Registered: September 2004
|
Junior Member |
|
|
hi Friends ,
I am here with facing problem creating data base link. I have two different database , and i need to create a DB link.
SQL> connect bikash/karan@sales.cos.com
Connected.
SQL> connect satish/satish@demo.cos.com
Connected.
Please clarify what is this host string : Is is demo.cos.com or sales.cos.com or is this something else................
SQL> create database link s_2_b connect to bikash identified by karan using demo.cos.com;
create database link s_2_b connect to bikash identified by karan using demo.cos.com
*
ERROR at line 1:
ORA-02010: missing host connect string
SQL> create database link s_2_b connect to bikash identified by karan using sales.cos.com;
create database link s_2_b connect to bikash identified by karan using sales.cos.com
*
ERROR at line 1:
ORA-02010: missing host connect string
Please help me out .......
demo.cos.com and sales.cos.com are on 2 diferent systems...
thanks and Regards
Bikash Karan
|
|
|
|
|
Re: how to create database link [message #623079 is a reply to message #623078] |
Thu, 04 September 2014 02:28 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
aravind90,
Welcome to the forum!
Please read and follow the OraFAQ Forum Guide to enable us to help you. You just brought up a 10 year old thread with a chit-chat message and it doesn't add anything to the information provided. I understand, the thread helped you as you said "That works", but going forward please follow the posting guidelines.
|
|
|