How to import an Oracle database from dmp file and log file?

How was the database exported?

• If it was exported using exp and a full schema was exported, then

  1. Create the user:

     create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>;
     

  2. Grant the rights:

     grant connect, create session, imp_full_database to <username>;
     

  3. Start the import with imp:

     imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y;
     

• If it was exported using expdp, then start the import with impdp:

  impdp <username>/<password> directory=<directoryname> dumpfile=<filename>.dmp logfile=<filename>.log full=y;
  

Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:\app\Vensi\admin\oratest\dpdump\).

Either move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.