Re: SQLLDR , Skipping fields

[Quoted] There no way to do it, as far as I know, unless you have a fixed position file. The best you can do is create a temp table, load the temp table and use the temp table to load your real table using a "insert into real_table select col1, col2, ... from temp_table" statement.

pmohanan_at_my-deja.com wrote:
>
> Hi..All,
>
> I am downloading the data from sybase to load into Oracle DB. Now,
> all the data fields in the data file are not required & its a variable
> length record. If the record looked like :
>
> Field1|Field2|field3|field4|field5|field6|field7|field8
>
> I want to pick only say, field1, field3, field7 & Field8. Is there any
> option in SQLLDR where I can specify which fields are needed.
>
> * Positions won't work as its a variable length record.
>
> Thanks a lot in Advance.
>
> Regards,
>
> Praveen Mohanan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jul 16 2000 - 00:00:00 CEST