RE: Connect to a remote database without a link

[Stephane Paquette]

Title: Message

You can always use sqlplus copy command to bring back some data without a db link.

 

Stephane Paquette

Administrateur de bases de donnees

Database Administrator

Standard Life

www.standardlife.ca

Tel. (514) 499-7999 7470 and (514) 925-7187

[EMAIL PROTECTED]

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor) (DAASC)
Sent: Tuesday, September 16, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Connect to a remote database without a link

Does anyone have an example of connecting to a remote database without a database link?  I think that I have seen it done before by putting in the username and password and tnsnames connection information right into the select statement.  Can it be done?

 

Tom