RE: Sqlplus COPY Command

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