Home » SQL & PL/SQL » SQL & PL/SQL » how to create database link
how to create database link [message #16249] Thu, 18 November 2004 10:46 Go to next message
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 #16251 is a reply to message #16249] Thu, 18 November 2004 13:28 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
You need to put the connect string within single quotes and use the connect string of the database that you want to connect to:

create database link s_2_b
connect to bikash
identified by karan
using 'sales.cos.com';
Re: how to create database link [message #623078 is a reply to message #16251] Thu, 04 September 2014 02:21 Go to previous messageGo to next message
aravind90
Messages: 1
Registered: December 2011
Location: Bangalore
Junior Member
Cool. That works.
Re: how to create database link [message #623079 is a reply to message #623078] Thu, 04 September 2014 02:28 Go to previous message
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.

Previous Topic: pragma autonomous
Next Topic: Global variable
Goto Forum:
  


Current Time: Thu Mar 28 15:39:18 CDT 2024