Toad World Blog

One-Step Schema Copy to the Cloud Using Data Pump!

Nov 10, 2015 1:21:00 PM by John Dorlon

In this blog, I'm going to copy the SCOTT schema from a private database, which is behind a firewall, to an Oracle Cloud database.  I should qualify "One step" as "One step once everything is set up", but set up is easy.  Details here.

 

So, I'm connected to the target Oracle cloud database and I click Database -> Import -> Datapump Import.  (Did you notice that we skipped the exporting and FTP'ing?  That's what makes this one-step!)

Click it to "Schemas", type in whatever schema you want to copy and click "Add".   Multiple schemas are fine, but I'm only doing one.

20151110153911.jpg-550x2000

 

In order for SCOTT (on the source database) to become SCOTT_NEW (on the target database), we need to provide the mapping.   Skip this if you aren't renaming anything.

20151110154320.jpg-550x2000

 

On the "Params" tab, choose the Database Link that points to the source database.

20151110154450.jpg-550x2000

 

On the "Files" tab, we only need to specify a parameter file (which contains all of the settings for Data Pump) and the log file (which is created on the server, in the specified directory.

20151110154650.jpg-550x2000

 

That's it!   Click the green triangle to start the import.  

20151110155435.jpg-550x2000

 

If you want to save these settings to repeat the process in the future, click the camera icon at the bottom of Toad's Data Pump window, and save the settings into the Automation Designer. 

20151110155618.jpg-550x2000

 

Then, when you want to re-run it, just go into the Automation Designer, rt-click your action and run it.  

20151110155913.jpg-550x2000

Tags: Toad for Oracle Cloud DBaaS

John Dorlon

Written by John Dorlon