Exforsys.com
 
Home Tutorials Oracle 9i
 

Tutorial 16: Oracle 9i: Oracle Utilities

 

Tutorial 16: Oracle 9i: Oracle Utilities - Page 2

Page 2 of 3



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.












Next Page: Tutorial 16: Oracle 9i: Oracle Utilities - Page 3


Read Next: Oracle 9i: SQL, PLSQL, and SQL *Plus - Introduction

 

 

Comments


pappu singh said:

  The section is very nice and easily understandable .
September 13, 2006, 4:27 am

PRAVEEN1 said:

  THE INFORMATION PROVIDED IS VERY USEFUL. THANKS A LOT
THERE IS ONE POINT LEFT WHILE CREATING CONTROL FILE IN NOTEPAD, YOU FORGOT TO MENTION INTO TABLE BLOCK.
May 7, 2007, 12:54 am

Salman Hunzai said:

  Thank you very much for this very informative sorce... It was very helpful indeed..
August 23, 2007, 3:11 pm

vijay said:

  great tutorial thanks a lot
November 7, 2008, 8:53 am

Kasi, Vijayakumar said:

  The section is easily understandable. Thanks in anticipation.
December 3, 2008, 3:54 am

rvnagarajan said:

  thanks a lot, very useful
January 2, 2009, 3:42 am

GM said:

  its explained step by step with screenshot, any layman can easily understand thanks
January 20, 2009, 10:25 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape