From: Sashi <smalladi_at_gmail.com>
Date: Thu, 1 Jul 2010 08:33:33 -0700 (PDT)
Message-ID: <30f0ad3f-ec8e-4a66-934e-e9b0b543e258_at_z8g2000yqz.googlegroups.com>

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?


      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))     )

      (SID = IV)

Sashi Received on Thu Jul 01 2010 - 10:33:33 CDT

Original text of this message