Re: reg : SQL LOADER

In article <835655606.16442.0_at_lantis.demon.co.uk> ash_at_lantis.demon.co.uk (Afshin Ghafoori) writes:
>M Rajeshwar <MR1154_at_CAMBER.COM> wrote:
>
>>How am i to load only selected columns from a flat file onto an oracle
>>table using sql loader ? I have found that it does not have a
>>provision to do this. Then how am I going over this problem ?
>
>You could do this in two stages:
>1) Load into a temporary table;
>2) Load the target table as a select from the temporary.
>
>How does this sound?
>
>

If your flat file is in a fixed format, all columns starting in the same position, SQL*Loader allows you to load selected fields based on position.

It's in the book.

-- 
David Stark          	  * Opinions expressed in this post are those of
stark_at_greenwich.com 	  * the author and do not in any way represent
Greenwich Associates      * an official statement by Greenwich Associates.
Greenwich CT  06831-5195  *