Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr missout first line
On 14 Mar 2002 04:05:23 -0800, dombaines_at_yahoo.com (Dominic Bines)
wrote:
>I have a series of files that need to be loaded to rows in a table one per
>row. The rows will have two columns only the second one is loaded for these files.
>
>They are CLOBs... each averages 200K characters, not all have a 80 column
>width so I can't just say start at character 80 either.
>
>At the start of every file content there is a series of information that is
>of no use and should/could be stripped out...
>
>Now I know it might be possible to use perl or something similar
>to create temporary files and load those...
>but how would you use sqlldr to ignore the first line of the
>file instead?
>
>Regards,
>
>Dominic
skip=<n> tells sqlloader the number of records to skip at the beginning of the file
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Thu Mar 14 2002 - 09:13:49 CST