no

How to restore an oracle dump using imp command

The following steps will guide us in the restoration of an oracle dump file. connect as system and enter your password sqplus system@xe ...

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.

Related

database 7513372869631489997

Post a Comment

item