Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resolving dblinks

RE: Resolving dblinks

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 24 May 2005 15:12:25 -0400
Message-ID: <00fa01c56094$85551860$8459000a@vttaxnet.tax.state.vt.us>


But since he did say he was using a tnsnames file, I thought that this would be the best way.

Ruth

-----Original Message-----

From: Michael Fontana [mailto:mfontana_at_verio.net] Sent: Tuesday, May 24, 2005 3:08 PM
To: rgramolini_at_tax.state.vt.us; george.rusnak_at_deca.mil; oracle-l_at_freelists.org
Subject: RE: Resolving dblinks

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruth Gramolini
Sent: Tuesday, May 24, 2005 10:19 AM
To: george.rusnak_at_deca.mil; oracle-l_at_freelists.org Subject: RE: Resolving dblinks

All databases which you want to access must be in the TNSNAMES.ORA on the host from which the request orginates. Just put an entry into your tnsnames.ora for this database.

HTH,
Ruth

<<

This is not exactly true. You can actually put the full connect string into the "create database link....using" command, and make a connection to the remote database internally. So a tnsnames.ora is not actually required.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 24 2005 - 15:17:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US