Monday, 12 September 2011

SQL Developer Data Pump Support - Part 2

Welcome to part 2 of this feature on our introduction of data pump functionality into SQL Developer.  Previously, we walked through exporting from the database.  This post will go through the importing the data export to a new schema in our database.
In the DBA navigator, go to the data pump node, and choose 'Data Pump Import Wizard'.

When the wizard appears, choose the type of import you want.   In our previous episode, we exported the 'BARRY' Schema.  We'll now choose to do a schema import.

For the input directories, choose a directory that exists and you have access to.  The dump files from the export session need to reside on this directory and conform to the filename as specified.
Hitting next, will parse the files and step 2 shows us the available schema to choose from.  Since we only export 'BARRY', we only have one to choose from in this case.
Step 3 involves remapping.  In this case, on my database, the Barry schema exists.  I need to create another schema to create these objects in.  I've done this already before we started the wizard.
Once the schema has been created and we're back in the wizard, we can set the destination as 'BARRY2'

Step 4 has two parts, one is for logging and we choose an appropriate database directory for that which exists and we have access to.  The second is for the actions on tables if they exist.  In my case, I want to replace them.  For this example, we know its a fresh schema with nothing in it, but if it did, we'd be replacing the tables.

Lastly, we can schedule the import, and like last time, I want to do this immediately.

The summary shows us what will be done on our behalf and once we hit the finish button, an import job will be created and kicked off immediately.

When the job starts, there will be an import job shown in the dba navigator.  its corresponding editor will show the job executing.

Finally, we can create a connection for the BARRY2 schema and look at the data.

 So, that's it in a nutshell.  Over two parts, we've shown you how to export any part of a database to file using the data pump utilities which have been integrated into Oracle SQL Developer.  In this part, we took those files from the previous post and imported them into Oracle.


Movies Gallery 2011 said...

Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
Vee Eee Technologies

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.