Re: ORA-02010

From: Sashi <smalladi_at_gmail.com>
Date: Thu, 1 Jul 2010 11:07:05 -0700 (PDT)
Message-ID: <cf4549fb-ea9a-4d27-a10f-195eaf7d2346_at_z10g2000yqb.googlegroups.com>

On Jul 1, 11:56 am, gazzag <gar..._at_jamms.org> wrote:
> 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

Ha! So that was it, huh?
Thanks a lot!
Sashi Received on Thu Jul 01 2010 - 13:07:05 CDT