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 for Windows

From: Charlotte Hammond
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