You could up your buffer size and also use impst.
Lee Robertson
Acxiom
Tel: 0191 525 7344
Fax: 0191 525 7007
Email: [EMAIL PROTECTED]
-Original Message-
Sent: 21 February 2001 16:07
To: Multiple recipients of list ORACLE-L
DBA's,
Does anyone have any tips for speeding up
Increase buffer to maximum possible may be 104857600(100MB).
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 21 Feb 2001 08:06:43 -0800
DBA's,
Does anyone have any tips for speeding up the import of a 10gb table with a
long_raw
Thanks Lee,
What is the impst command? I'm not familiar with it.
...JIM...
[EMAIL PROTECTED] 2/21/01 10:21:01 AM
You could up your buffer size and also use impst.
Lee Robertson
Acxiom
Tel: 0191 525 7344
Fax: 0191 525 7007
Email: [EMAIL PROTECTED]
-Original Message-
Sent:
Single stream import. I have noticed significant gains in the past when
using this but to be honest I haven't yet used it on an Oracle 8 database
(someone else out there may be able to say if it still performs).
Go to $ORACLE_HOME/rdbms/lib and type
make -f ins_rdbms.mk impst
if this doesn't
It is a imp linked single task: make -f ins_rdbms.mk impst. In this case,
you don't go through the listener.
Regards.
-Mensaje original-
De: James Howerton [SMTP:[EMAIL PROTECTED]]
Enviado el: mircoles 21 de febrero de 2001 17:51
Para: Multiple recipients of list ORACLE-L