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