Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader - start on secondline

Re: SQL*Loader - start on secondline

From: Keld Nielsen <keldnielsen_at_image.dk>
Date: Sat, 23 Mar 2002 19:49:25 +0100
Message-ID: <zf4n8.13034$ZI6.631258@news000.worldonline.dk>


you could start out by searching the groups, however here is an answer from Sybrand (hope you don't mind Sybrand !)

Quote
skip=<n> tells sqlloader the number of records to skip at the beginning of the file

Regards

Sybrand Bakker, Senior Oracle DBA
Unquote

> Hi there,
>
> is there a way to let sql-loader start on the second-line of a
> data-file? Since I've got the header of the data-file in the
> first-line, I want to start in the second line.
>
> If yes, how?
>
> Thanx for help,
>
> Christian Hartmann
>
Received on Sat Mar 23 2002 - 12:49:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US