Importing .dmp file via command prompt

The imp utility is used to import the contents of a dump file into an Oracle database. To import the entire contents of the dump file, use the FULL=Y parameter as follows:

imp userid=system/manager file=my_dump.dmp full=y log=imp.log

I always log the output to a file so that I can refer back to it should there be errors.

For more information on the import utility, please refer to the Oracle documentation. Go to http://tahiti.oracle.com, and click on your specific version. Then click on the Books links and look for the Utilities guide.