Re: For the GURUS - Load Process slowing down
From: John Griffin <jgriffin_at_boyne.u-net.com>
Date: Tue, 06 Jul 1999 22:06:52 +0100
Message-ID: <37826FEC.CD659887_at_boyne.u-net.com>
Date: Tue, 06 Jul 1999 22:06:52 +0100
Message-ID: <37826FEC.CD659887_at_boyne.u-net.com>
Yeah - I agree - I have done a lot of this in the past and the fastest way of getting data into your database is to drop the PK and any indexes, use Direct Path SQl*Load (which should load about a million rows in a few seconds) and finally rebuild your PK.Indexes.
Sinead wrote:
> Have you looked into using Sql*Loader in Direct Path ? Rebuilding indexes
> after load? Another suggestion is to remove indexes, run sql*loader then
> add indexes after.
> -
Received on Tue Jul 06 1999 - 23:06:52 CEST