RE: [External] : FW: Sqlplus COPY Command

Thanks for that feedback Mark – it’s good to see what folks are actually doing in the REAL world.

Obviously we know one of the biggest tasks is loading/getting data into your database. And there’s 27 methods out there to choose from! So it’s very valuable to know COPY is still a viable/popular route to take for you.

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mark W. Farnham Sent: Monday, August 23, 2021 2:06 PM
To: 'oracle-l-freelist' <oracle-l_at_freelists.org> Subject: [External] : FW: Sqlplus COPY Command

(not sure why this missed the list…)

Nice work!

From: Mark W. Farnham [mailto:mwf_at_rsiz.com] 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_at_jokr.net] Sent: Friday, August 20, 2021 1:20 PM
To: Mark W. Farnham
Cc: charlottejanehammond_at_yahoo.com<mailto:charlottejanehammond_at_yahoo.com>; 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_at_rsiz.com<mailto:mwf_at_rsiz.com>> 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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of kris rice Sent: Friday, August 20, 2021 11:42 AM
To: mwf_at_rsiz.com<mailto:mwf_at_rsiz.com> Cc: charlottejanehammond_at_yahoo.com<mailto:charlottejanehammond_at_yahoo.com>; 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_at_rsiz.com<mailto:mwf_at_rsiz.com>> 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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Charlotte Hammond (Redacted sender "charlottejanehammond" for DMARC) Sent: Thursday, August 19, 2021 7:45 AM To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>; 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_at_hotmail.com<mailto:dombrooks_at_hotmail.com>> wrote:

SQLCLI? https://connor-mcdonald.com/2019/08/05/take-a-copy-out-of-sqlcls-book/<https://urldefense.com/v3/__https:/connor-mcdonald.com/2019/08/05/take-a-copy-out-of-sqlcls-book/__;!!ACWV5N9M2RV99hQ!ZrsplxFGMGKw04BwuvqF6wW1eNMoVHuYEEtEozlgHnUpYzHmzZIYyTl2qul-G20RJqg$>

Sent from Mail<https://urldefense.com/v3/__https:/go.microsoft.com/fwlink/?LinkId=550986__;!!ACWV5N9M2RV99hQ!ZrsplxFGMGKw04BwuvqF6wW1eNMoVHuYEEtEozlgHnUpYzHmzZIYyTl2qul-GaRUXE8$> for Windows

From: Charlotte Hammond<mailto:dmarc-noreply_at_freelists.org> Sent: 19 August 2021 10:03
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> 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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 23 2021 - 21:57:28 CEST