Hi all, I'm trying to create a database link to a remote db.

SQL> create public database link iv_link
2 connect to user identified by password
3 using IV;


IV is the SID identifier in my tnsnames.ora for the remote host.
this results in ORA-02010.

How do I specify the host connection string when I have the DB
connection string as below? Should I create one before I can create a
DB link?

IV = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.44)(PORT = 1521))
)
(CONNECT_DATA =
(SID = IV)
)
)

TIA,
Sashi

On 1 July, 16:33, Sashi <small... (AT) gmail (DOT) com> wrote:
Sashi,

You need a single quote (') around the connect string. Your SQL
statement should read:

create public database link iv_link
connect to user identified by password
using 'IV';

HTH
-g

On Jul 1, 11:56*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Ha! So that was it, huh?
Thanks a lot!
Sashi