Re: how to skip columns in sqlldr

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:afch7v0463561nlk2nj6qfjfllqd9uomem_at_4ax.com...
> On Wed, 19 Mar 2003 17:00:44 +0000, Dave <recneps.w.divad_at_elcaro.moc>
> wrote:
>
> >you could read the data into a temporary table, use SQL to copy the data
> >you want then drop the temporary table, perhaps something like:
> >
> >insert into test select p,9999,q from temp_table;
> >
> >where p and q are the two columns in temp_table.
> >
> >Dave.
> >
>
>
> All of this is *COMPLETELY* unnecessary, provided the control file has
> been setup correctly.
>
> Also please observe netiquette and respnd *below* the question.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

• Netiquette is one thing - getting the answer was probably more important to this person. Play the game mate.

What may do the trick for you is the use of FILLER in the control file in place
of the actual column required. Look at http://tahiti.oracle.com for online versions
of the manual - look at the Utilities User guide which should provide the examples etc.

Regards
Martin Received on Wed Mar 19 2003 - 20:19:44 CET