-1

I’m looking to copy a remote Oracle (19) database schema to a local database (Oracle 23 container in Docker)

I was exploring expdp but it only exports a db dump in the remote db’s file system. I’m looking for similar tool that lets me do something similar to sqldeveloper’s database copy tool but be able to run it from the command line so I can update my local db from the remote one

joopabs
  • 17
  • 2
  • For Oracle-supported tools, expdp/impdp is the only command-line option. You can use the `DBMS_DATAPUMP` PL/SQL API to run it as a stored procedure from inside the database and pull data through a database link, or run it from the command line and use scp or sftp to copy the dump file between servers. – pmdba Aug 31 '23 at 18:40
  • that's not true, we have SQLcl which offers these kinds of features – thatjeffsmith Aug 31 '23 at 19:26

0 Answers0