Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr missout first line
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 Received on Thu Mar 14 2002 - 06:05:23 CST
![]() |
![]() |