These are the parameters u need to consider while exporting and
importing

Export

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


While Importing

BUFFER=2M
COMMIT = YES ( To avoid Undo or Rollback segment Errors Since
u'rs is large database)
INDEXES = N ( So that you can rebuild using parallel and
nologging option)


Hopes this will improve performance for export and import.

Regards
Prasad



-----Original Message-----
From: Irfan Khan
[mailto:oracledba-ezmlmshield-x38384578.[Email address protected]
Sent: Monday, May 31, 2004 4:09 PM
To: LazyDBA.com Discussion
Subject: RE: improving - Export and import parameter

If ur export dump file being created on the same drive as that of ur
tables , and same for Import.

Though in this case not sure for export, but import very sure, after i
did remotely from other server the import it went in an hours time,
where by on the same disk , it took 12 hours+ to complete.

Bottomline is look for Contention

Regards
IK

-----Original Message-----
From: Kishore A
[mailto:oracledba-ezmlmshield-x92483866.[Email address protected]
Sent: Monday, May 31, 2004 3:27 AM
To: LazyDBA.com Discussion
Subject: improving - Export and import parameter




What are the parameters which will improve the performance
while export and importing a large database !!!

Regards,
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.
************************************************************************
****


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address
protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page