How To Restore An Oracle Dump Using Imp Command

The next steps volition direct us inward the restoration of an oracle dump file.

1. connect equally organisation as well as operate inward your password

sqplus system@xe 

2. create user

create user TEST_USER identified past times 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 tabular array 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 higher upwards steps is amongst the supposition that we've created an oracle database backup using exp tool.