How to Restore an Oracle Dump Using Imp Command

The following steps will guide us in the restoration of an oracle dump file.

1. connect as system and enter your password

sqplus system@xe

2. create user

create user TEST_USER identified by password;

3. grant roles

grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, -
  CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, -
  CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - 
  CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE -
  to TEST_USER;

4. create permanent table space

CREATE TABLESPACE testuser DATAFILE 'testuser.dat' SIZE 20M AUTOEXTEND ON;

5. import the dump file

imp system/password@xe file=d:\testuser.dmp fromuser=TEST_USER touser=TEST_USER log=d:\test_user_import.log

The above steps is with the assumption that we've created an oracle database backup using exp tool.