RE: Sqlplus COPY Command

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] On Behalf Of Charlotte Hammond (Redacted sender "charlottejanehammond" for DMARC) Sent: Thursday, August 19, 2021 7:45 AM
To: 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> 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_at_freelists.org> Sent: 19 August 2021 10:03
To: 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