Re: SQL Loader: How to skip fields?

[Quoted] If the extra fields are at the end, don't include them in the control file. It will load fine. If the field is in the middle, my dba loads that into a temp table, then copies the good fields to the correct table and then dumps the table. I couldn't find a 'skip field' notation in sqlldr. It will ignore extra data on the end past your last defined field.

Doug

Christoph Meyer wrote:

> Hi!
>
> I'm trying to load a data file with each record containing 3 fields (col_A,
> col_B, col_C) using SQL*Loader.
> The table in the database, however, contains 2 fields only (field1, field2)
> What's the syntax for the loader script to load:
> col_A into field1,
> col_C in field2 and
> skip col_B?
>
> Any suggestions? Thanks in advance.
> Christoph Meyer
>
> ---
> Please remove [nospam] before replying.
Received on Thu Jan 20 2000 - 00:54:07 CET