How to import the .dmp file in Oracle 9i (in the 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.