Re: SQL loader
From: Holger Spangardt <Holger.Spangardt_at_web.de>
Date: Sun, 22 Sep 2002 21:39:02 +0200
Message-ID: <3D8E1C56.607_at_web.de>
Date: Sun, 22 Sep 2002 21:39:02 +0200
Message-ID: <3D8E1C56.607_at_web.de>
Hi,
what is fast for you? SQL-Load with direct path is fast.
I think there is no faster way.
What is your hardware, what size has tha ascii-file and how many indexes
have to rebuild after loading the data?
Are there any clauses in the ctl-file?
How are the memory parameters?
May be you have to increase sort area size to improve the index rebuild.
Hope this helps,
Holger
Fredrick Jeyakumar Roberts wrote:
> How can I do to sqlloader work faster.
> I tryed the DIRECT option, same result with no logging in the create tables
> //
>
Received on Sun Sep 22 2002 - 21:39:02 CEST