Date: Thu, 1 Jul 2010 08:33:33 -0700 (PDT)
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 = (PROTOCOL = TCP)(HOST = 220.127.116.11)(PORT = 1521)) )
(SID = IV)
Sashi Received on Thu Jul 01 2010 - 10:33:33 CDT