Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sqlldr: how to skip header records
Hello,
I'm "playing" with sqlldr to import csv files into Oracle.
It's a hard way.
It seems that the pre-condition how an import file must
look like so that sqlldr can import it are very restrictive.
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
I used this control file:
I also tried different positions of the skip command. the error message remained the same.
Any idea what's the reason why?
Regards,
Sönke
Received on Fri Feb 28 2003 - 05:42:46 CST