ORA-02010

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?

IV = (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 11.22.33.44)(PORT = 1521))     )
(CONNECT_DATA =

      (SID = IV)
    )
  )

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