Re: sqlldr: how to skip header records

From: FC <flavio_at_tin.it>
Date: Fri, 28 Feb 2003 11:53:09 GMT
Message-ID: <F4I7a.249322$0v.6934453@news1.tin.it>

You must use SKIP at the command level, not inside the control script

Sqlldr <usr>/<pwd> CONTROL=<ctl_file> SKIP=1

Bye,
Flavio

"Sönke Petersen" <sk.petersen_at_gmx.de> wrote in message news:b3nhrr$dga$1_at_news.mch.sbs.de...

> Usually I leave a list of column names as the first record
> of a csv file. Relating on Oracle documentation one
> could skip such a header record by using the skip command
> within the control file.
>
> I didn't work. I got the following error message:
>
> SQL*Loader-410: Number to skip must be load-level, not table-level
>
Received on Fri Feb 28 2003 - 05:53:09 CST