RE: DB Link Help

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

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

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