Hi Stephen,
The COPY command is a SQL*Plus command and allows SQL*Plus to act as a
"pipe" for want of a better description between two databases to copy
data. It is deprecated as far as I know? and i don't think it handles
some of the newer data types.
I think the OP meant from within SQL rather
0 (or whatever)
I like the command. It seems to do a decent job of hauling over sizable
chunks of data.
> -Original Message-
> From: Pete Finnigan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 16, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
]
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor)
(DAASC)Sent: Tuesday, September 16, 2003 11:15 AMTo:
Multiple recipients of list ORACLE-LSubject: Connect to a remote
database without a link
Does anyone have
an example of
The COPY command does NON-dblink connect to the remote database.
-Original Message-
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 informatio
Title: Message
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
