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
  2. sqplus system@xe
    
  3. create user
  4. create user TEST_USER identified by password;
    
  5. grant roles
  6. 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;
    
  7. create permanent table space
  8. CREATE TABLESPACE testuser DATAFILE 'testuser.dat' SIZE 20M AUTOEXTEND ON;
    
  9. import the dump file
  10. 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.
How to restore an oracle dump using imp command How to restore an oracle dump using imp command Reviewed by Edward Legaspi on Tuesday, July 15, 2014 Rating: 5

No comments:

Powered by Blogger.