How to restore/import an Oracle database from dmp file?

It depends what you are trying to do but one short answer is:

imp system/password@sid file=(filename) log=imp.log fromuser=(existing user) touser=(new user)

The last 3 here: log, fromuser, touser are optional. You might give some more details about what you are doing if that doesn't help...

It depends on the type of export (dump) that was done from the original database. Oracle does four types of exports (called modes):

Assuming that a Full export was done, you'd do something like:

SET ORACLE_SID=dbsid
imp system/manager FULL=y FILE=database.dmp LOG=import.log STATISTICS=recalculate

Having said that, you should read through the Oracle documentation on imp.

Related