Re: SQL*Loader: skip columns on import

John,

        I've got a stupid question. How many records are you loading in the average run? The reason I ask is that running SQL*Loader against Oracle 7.2.2.4 on a Pentium running NT I am able to load 175,000 records (fixed format) in under a minute when using direct path loads.

        Given the speed of SQL*Loader the following quick and dirty alternative may be a worthwhile solution to your problem:

1. create a temporary table with that extra column,
2. run a direct path load into the temporary table,
3. insert the desired data into your target table.

Jerry

H. John C. Hopkins wrote:
>
> Can't find this in the manuals:
>
> How do you skip columns when loading from a comma-delimited file; in
> particular, how do you skip the first column?
>
> Thanks much!
>
> -John
Received on Wed Oct 08 1997 - 00:00:00 CDT