RE: DB Link Help

  • From: "Post, Ethan" <Ethan.Post@xxxxxx>
  • To: <dofreeman@xxxxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 May 2005 15:23:32 -0500

create database link templink connect to foo identified by blah using
'(DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 255.255.255.255)(PORT =3D =
1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D foodb)
    )
  )
';=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Wednesday, May 25, 2005 3:17 PM
To: Oracle-L (E-mail)
Subject: DB Link Help

I once had this and now can't find it.  I know that you can connect =3D
through a db link using the entire tns connect string for the link.  I =
=3D
don't remember if it had to be predefined or not.  I was troubleshooting
=3D
a link at the time and stumbled across the syntax but now can't find it.
=3D
 I've been having trouble with a link being unavailable the first time =
=3D
its is used after the db has been down.  I am thinking that I want to =
=3D
either create it at run time or just use the entire connect string in a
=3D
script.  Can anyone share some examples or the syntax for this? =3D20

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology
717-783-8095 Ext 337

--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Other related posts: