Exforsys

Home arrow Technical Training arrow Oracle 9i Training

Oracle 9i Utilities Page - 2

Page 2 of 3
Author : Exforsys Inc.     Published on: 30th Apr 2005    |   Last Updated on: 23rd Nov 2010

Oracle 9i Utilities

Ads

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.

Ads









 
This tutorial is part of a Oracle 9i Training tutorial series. Read it from the beginning and learn yourself.

Oracle 9i Training

 

Comments