Home » Infrastructure » Other Operating Systems » Export & import under Oracle 8i under Novell 5.1 is very slow
Export & import under Oracle 8i under Novell 5.1 is very slow [message #73006] Tue, 13 January 2004 19:20 Go to next message
Shah Alam Patwary
Messages: 1
Registered: January 2004
Junior Member
Export & import under Oracle 8i under Novell 5.1 is very slow : How can we improve it.
Re: Export & import under Oracle 8i under Novell 5.1 is very slow [message #73009 is a reply to message #73006] Wed, 14 January 2004 02:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
for export, incresase ur buffersize.
for import , first
remove/disable the indexes.
load the data
rebuild the indexes.
have the tablespace in nologgingmode.
Re: Export & import under Oracle 8i under Novell 5.1 is very slow [message #73099 is a reply to message #73009] Mon, 02 February 2004 17:19 Go to previous message
Ian Timms
Messages: 4
Registered: November 2001
Junior Member
You could try performing a Direct Path export/import as this would be considerably faster. And also try using the statically linked version of exp and imp executables, again inclined to be faster.

Regards, Ian.
Previous Topic: Anybody still using Oracle on Novell???
Next Topic: VMS
Goto Forum:
  


Current Time: Fri Jun 18 00:50:30 CDT 2021