Re: ORA-02010
From: gazzag <gareth_at_jamms.org>
Date: Thu, 1 Jul 2010 08:56:10 -0700 (PDT)
Message-ID: <1a4e6eeb-5dd2-4a6a-b06f-6651361dfeea_at_r27g2000yqb.googlegroups.com>
On 1 July, 16:33, Sashi <small..._at_gmail.com> wrote:
> 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
Date: Thu, 1 Jul 2010 08:56:10 -0700 (PDT)
Message-ID: <1a4e6eeb-5dd2-4a6a-b06f-6651361dfeea_at_r27g2000yqb.googlegroups.com>
On 1 July, 16:33, Sashi <small..._at_gmail.com> wrote:
> 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
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
Received on Thu Jul 01 2010 - 10:56:10 CDT