imp Utility

imp Utility

imp Utility :- This utility is used to restore the database or schema or tables Using export dump.

We can import below through imp utility  

   

    1)  Import full database

    2) Import one or more specific Schemas/Users

    3) Import one or more specific Tables

    4) Import all objects in a Tablespace

There are 3 level of import available 
   1) Database  
   2) Schema  
   3) Table     

Features available in import utility :-

    1) We can restore one or more tables from export dump

    2) We can restore one or more schemas from export dump

    3) We can restore complete database

    4) We can restore database object like constraints, grants, triggers and indexes

   

There are three methods to connect using imp utility to restore data from export backup

   1) Interactive     
   2) Non-Interactive           
   3) Parameter file.

1. Interactive Mode:-When we write imp command on command prompt and hit enter, we enter the interactive mode, where it will prompt you for various values before exporting the Oracle table data.

First, it will ask for the Oracle schema’s username and password.

This username can be the name of the schema that you are planning to export, or a username who has DBA privilege to export other user’s objects.

Example 1:- Restore scott schema by interactive mode using scottdump.dmp file

Note:- Before going to restore user "scott" we need to create scott user first then need to grant appropriate permissions .

 

1. Non-Interactive Mode:- When we put all commands in one line on command prompt then this method is called non-interactive mode.

Example 1:- Restore emp and dept table from scottdump.dmp