There are several factors that could be accounting for the difference, but
are you doing a direct load? If not, you should. Also, if you can do a
direct load on the database machine, this will always give the best
performance.

Good Luck!
Chris

----------------------------------------------------
Chris Weiss, Blueoak Database Engineering, LLC
http://www.blueoakdb.com
PH: 517-381-9305
CELL: 517-974-5634
eFAX: 801-340-0740


-----Original Message-----
From: Trace R Jones
[mailto:oracledba-ezmlmshield-x58888608.[Email address protected]
Sent: Friday, August 27, 2004 8:30 AM
To: LazyDBA Discussion
Subject: sql loader taking longer in 9i than 8i






We have two versions of the same database. SQL Loader in 9i is taking much
LONGER than in the 8i database. We've ruled out network issues already.
Anyone have any ideas?

TRJ



--------
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: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page