Re: Import Utiltiy

Alianto writes in <36b92366.0_at_news1.ibm.net> ...
>Most of our client use Oracle 7.x.x database running under HP 9000.
>We usually refresh data from one machine to another machine, and so far we
>didn't any problem with export/import utility.
>
>I have some questions about import utility :
>1. How to increase import performance ?

   Try to

1. Add parameter COMMIT=Y
2. Increase buffer size (BUFFER=...)
3. Add parameter COMMIT=Y AND Increase buffer size :-)

>2. Where can I find some information that will increase import performance
?

    Oracle7 Server Utilities Release 7.3 February 1996, Part No. A32541-1

Valery Yourinsky
---
Softservice, Moscow
ORACLE PARTNER
tel/fax (095) 333-63-10, 128-18-21
http://www.softexpress.ru
ICQ# 368 97 94
second E-mail: vsur_at_usa.net Received on Thu Feb 04 1999 - 05:03:23 CST