OraFAQ Forum: Other Operating Systems » Export & import under Oracle 8i under Novell 5.1 is very slow

Home » Infrastructure » Other Operating Systems » Export & import under Oracle 8i under Novell 5.1 is very slow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export & import under Oracle 8i under Novell 5.1 is very slow [message #73006]

Tue, 13 January 2004 19:20

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.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Anybody still using Oracle on Novell???
Next Topic:	VMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 05:08:16 CST 2025