Re: SQL Loader, skip records, header and footer

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 19 Mar 2003 11:52:57 +0500
Message-ID: <b5944i$26t9u7$1@ID-127142.news.dfncis.de>

Look at LOAD keyword. It is not exactly what you want of course, but I guess if you know the number of records to skip and the total number of records, so you can calculate the number of records to load.

From docs:

LOAD (records to load)
LOAD specifies the maximum number of logical records to load (after skipping the
specified number of records). By default all records are loaded. No error occurs if
fewer than the maximum number of records are found.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


"Michel R." <michelr_at_hydro.qc.ca> wrote in message
news:gKpda.23874$eD6.223410_at_wagner.videotron.net...


> Hello all,

>

> Is it possible to also tell SQL Loader to skip a certain number of lines

at


> the end of the data file, like we can tell SKIP=1 for the start of the

file?


>

> Michel.

>

>

Received on Wed Mar 19 2003 - 00:52:57 CST