Oracle 9i Utilities Page - 2

Fig 1 explains how to use EXP utility in interactive mode.

Fig 2 illustrates exporting data from multiple tables non-interactively (by giving the giving the parameters in the command).

Exporting data from a table conditionally:

Fig 3 gives the screen shot to export employees of deptno = 10 .

Suppose if you want to export data of employees with salary less than 2000 then the following query can be used.

EXP SCOTT/TIGER FILE= abc.dmp TABLES=emp QUERY=” WHERE SAL < 2000 ”

Note: QUERY parameter is available from Oracle 8i

Import Utility

This utility is used to extract objects (tables etc) from the export file (.dmp file) created using EXP utility.

IMP command can be used to invoke import utility interactively without any parameters. (Which Requests the user to enter the value). Otherwise parameters can be specified in a file called parameter file. We can use more than one parameter file at a time with exp command.

Syntax:

imp username/password PARFILE = filename
(Or)
imp PARFILE = filename

Parameter file is a simple text file creating using any text editor.

Fig. 4 explains the usage of IMP utility with parameters (non-interactively) in the command-line.