(not sure why this missed the list…)
Nice work!
From: Mark W. Farnham [mailto:mwf@xxxxxxxx] ;
Sent: Friday, August 20, 2021 8:32 PM
To: 'kris rice'
Subject: RE: Sqlplus COPY Command
Actually reading the update of the command COPY from SQLcl, I believe applause
is in order.
Forgive me being out of date, especially since I was less than subtle that COPY
in sqlplus was not updated to handle types introduced circa 8i, most especially
LOB.
I now see that you have thoroughly modernized type support in the SQLcl version
of COPY.
Applause.
From: kris rice [mailto:kris.rice@xxxxxxxx] ;
Sent: Friday, August 20, 2021 1:20 PM
To: Mark W. Farnham
Cc: charlottejanehammond@xxxxxxxxx; oracle-l-freelist; Dominic Brooks
Subject: Re: Sqlplus COPY Command
My only plan is to build what people need :). Do you have examples of what
copy doesn't and bridge doesn't do?
-kris
On Fri, Aug 20, 2021 at 12:24 PM Mark W. Farnham <mwf@xxxxxxxx> wrote:
That is excellent news on both counts.
Do you know if there is any plan to include newer types in COPY, or is it just
being left alone regarding features but made to work in new releases so that
old suites of scripts and so forth don’t stop working for lack of a functioning
COPY command?
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of kris rice
Sent: Friday, August 20, 2021 11:42 AM
To: mwf@xxxxxxxx
Cc: charlottejanehammond@xxxxxxxxx; oracle-l-freelist; Dominic Brooks
Subject: Re: Sqlplus COPY Command
in sqlcl, copy is not deprecated and no plans to do so. That said the bridge
command is nice and even allows the copy to happen from non-oracle to oracle.
This command came about from some of the migration projects we were asked to do
from X -> Oracle.
-kris
On Fri, Aug 20, 2021 at 9:32 AM Mark W. Farnham <mwf@xxxxxxxx> wrote:
Last time I had a conversation about this with folks at Oracle this was a
deprecated but not likely to be scheduled to be removed tool (for good reason).
You are an example of the good reason. And, as long as you don’t have any
newfangled column types and you understand that you need to set long at least
as long as your longest long unless you want silent truncation into the
destination, it has always been a spiffy and efficient way to copy data
directly between databases over the network.
Mind your arraysizes and copycommit and you should be fine.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Charlotte Hammond (Redacted sender "charlottejanehammond" for DMARC)
Sent: Thursday, August 19, 2021 7:45 AM
To: oracle-l@xxxxxxxxxxxxx; Dominic Brooks
Subject: Re: Sqlplus COPY Command
Thanks Dominic,
I had vaguely thought that the COPY command in SQLcl would have the same sort
of deprecation warning as in Sqlplus, but I'm not sure if that's actually the
case - anyone able to clarify please? I see in the comments in the link that
somebody suggested using BRIDGE instead, but certainly either of those 2
options might be exactly what I'm looking for.
Charlotte
On Thursday, August 19, 2021, 10:48:28 AM GMT+1, Dominic Brooks
<dombrooks@xxxxxxxxxxx> wrote:
SQLCLI?
https://connor-mcdonald.com/2019/08/05/take-a-copy-out-of-sqlcls-book/
Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
From: Charlotte Hammond <mailto:dmarc-noreply@xxxxxxxxxxxxx>
Sent: 19 August 2021 10:03
To: oracle-l@xxxxxxxxxxxxx
Subject: Sqlplus COPY Command
Hello All,
I have a sqlplus client connection to 2 Oracle DBs on 2 separate networks, with
no access to the hosts.
The sqlplus COPY command works a treat for moving smallish volumes of data
between them from the client. But the documentation says that this will be
deprecated in future releases (although I can see it's still in the 21c
documentation).
Assuming I don't want to develop a new process based on the COPY command what
would be a better way to do this? (I can't install a database on the client,
so database links are out, and there is no network connectivity from
DB->client).
Thanks!
Charlotte
