Recently I was contracted by a client to work on a large Oracle database that was to be integrated with a PHP program he was revamping. When we began work, he gave me a database schema in the form of a dump (.dmp) file. This file was to be imported into Oracle, and would automatically load the tables, binds, triggers, data, etc. I did some scouring on the internet and finally came upon how to import the database.

To begin, place your .dmp file in your admin\XE\dpdump\ folder. I am running my server locally on my laptop, so this location is

C:\oraclexe\app\oracle\admin\XE\dpdump

This location may be different depending on where you installed oracle. I prefer to put my dump files in the dpdump folder so that I don't have to specify a directory when doing the import.

Next you should open up your command line utility and type the following command



The data pump import utility will begin running and outputting it's progress to the screen. It will generate your tables, triggers, binds, and fill the data in. Basically it will make an exact replication of the database it was exported from. After this is complete check your errors. If there were none, you're good to go!

Hopefully this tutorial helps you get through this task without having to scour the internet. Take care, and good luck with Oracle!

hi,
its worth, but which user this dump will add to.
suppose i have 2-3 users in oracle, and i have dump and i want to import it to another user, then what will be the command line argument i need to pass.