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.
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.
View comments