For one, we could continue our SQLcl session with all the OCI locations/profiles set and just log into a cloud database, or we could start from a new session and set our OCI variables again.

Now letвЂ™s import the file into a cloud database. Over in the OCI Web Console, if I bring up the datapumpDemo bucketвЂ™s contents, I can see the export. There are a few variables at play here with networks and please be cognizant of speed and size to that expectations are set correctly. If you have a very robust connection to OCI and the export is of reasonable size (a few GB), then this process will be quite fast. This is the part where your mileage will vary. The -copycloud flag tells SQLcl to stream the export file from the database to the client then immediately put the file into object store in the cloud using the bucket we supplied earlier. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Log Location: DATA_PUMP_DIR:ESQL_1738.LOG You simply call Data Pump at the SQLcl prompt with dp. Why not use Data Pump? Even better, why not use Data Pump in SQLcl to connect to any database on the fly and issue 2 simple commands to perform this task? Imagine a common migration scenario you need to move a local database from one server to another for some reason or another. ItвЂ™s SQLcl, of course (you probably guessed that from the title of this article), and with the 21.4 release of SQLcl in December of 2021, we added Data Pump functionality to help aid in this quest. While there are many tools to help with Oracle Database Migration, canвЂ™t we just get it down to a simple command? And can that same mythical tools help move these exports to other magical lands like the cloud?Дoes such a tool exist to slay this ever-foreboding specter of simple database migration? It must be done, but you are not looking forward to it.

It turns into this looming task that hangs over you like a black cloud. It is often a significant hurdle in working with databases for developers unfamiliar with the process. Database migration is not a fun or easy activity.

Oracle database migrations