Re: sqlload a big ora7 table ?

From: Devinder Pal Singh <devinder.palsingh_at_pharma.novartis.com>
Date: Tue, 19 Jan 1999 15:43:30 -0500
Message-ID: <36A4EE72.AC982B9B@pharma.novartis.com>

Use the direct load option and presort your data if you want to create the index along with load and mention it in the control file, there is a parameter I always forget.
Dave

Thomas Wenrich wrote:

> Hi,
>
> Just wondering whether there is a *fast* way to load data into a table
> with an index (without re-creating the index) ?
>
> The loader runs since 24 hours now and still needs to process the other
> half of the two million rows. System is a SCO 3.2.4 200MHz Pentium.
>
> Thanks,
>
> Thomas
Received on Tue Jan 19 1999 - 14:43:30 CST