Hi Prasad,

Thanks for all the tips. Just to summarize

Improving performance while Export
---------------------------------
DIRECT= Y
BUFFER = 2M (its u'r choice generally I will keep 2M)
RECORDLENGTH = 64K

Improving performance while Import
---------------------------------

BUFFER=2M
COMMIT = YES ( To avoid Undo or Rollback segment Errors Since
u'rs is large database)

Case 1> If already indexes/triggers are present
> disables the indexes/triggers
> import the data using BUFFER and COMMIT

Case 2> If it's fresh import
> Import the dump with INDEX=N, also use BUFFER and COMMIT
> Next, create the index file using
indexfile=index.sql and rows=n and the script file


Anybody wants to add some more tips !!

Thanks
Kishore
****************************************************************************
This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.
****************************************************************************

Oracle LazyDBA home page