Import in Oracle

                                       Import Utility in Oracle

         The Import utility provides a simple way for you to transfer data objects between Oracle databases,even
if they reside on platforms with different hardware and software configurations.
         When you run Export against an Oracle database, objects (such as tables) are extracted, followed by
their related objects(such as indexes, comments, and grants), if any. The extracted data is written to an export dump
file.The Import utility reads the object definitions and table data from the dump file.Data Pump Import is a utility
forloading an export dump file set into a target system.The dump file set is made up of one or more disk files that
contain table data, database object metadata, and control information. The files are written in a proprietary,
binary format.Import can also be used to load a target database directly from a source database with no intervening files,
which allows export and import operations to run concurrently,minimizing total elapsed time. This is known as network
import.tHE command for import is as follows.

imp userid=userid/password file=exp.dmp fromuser=username

for userid you have to give username and password then the file name.dmp and finally the username.This command will
import the file in the database.If you want to import particular database,users,tables then you have to pass the parameter
the command is

From command line
IMP

USERNAME
USERNAME is the first parameter on the command line

PASSWORD
Then enter password    
 
Import file
then you have to give the file name

Enter import buffer size
then you have to enter the buffer size

List contents of import file only
if you want the contents of the import file yes or no

import entire export file
the last parameter is the import the entire export file

For Example
I want to import a table gary
then from command line