Importing .dmp file via command prompt
How to import the .dmp file in Oracle 9i (in the command prompt)?
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.