Prev: Kool Infographics & data reporting site
Next: Energy Saving Tips
From: Sashi on 1 Jul 2010 11:33
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
From: gazzag on 1 Jul 2010 11:56
On 1 July, 16:33, Sashi <small...(a)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
From: Sashi on 1 Jul 2010 14:07
On Jul 1, 11:56 am, gazzag <gar...(a)jamms.org> wrote:
> On 1 July, 16:33, Sashi <small...(a)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
 | 
Pages: 1
Prev: Kool Infographics & data reporting site
Next: Energy Saving Tips