Re: sql*loader v1 vs. v2

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Mar 1999 00:15:13 +0100
Message-ID: <36ED9480.9968128E@sybrandb.demon.nl>

If you know how many header records there are you can specify skip=<n> in your controlfile.

Hth,
Sybrand Bakker, Oracle DBA

go_brien_at_my-dejanews.com wrote:

> SQL*Loader question
> I have a ctl file that read a .dbf (dbase file) with no problem under
> oracle6/sqlloader v1. It does not work in Oracle7.
> How do I modify it so that Oracle7/sqlloader v2 will correctly load the data
> into Oracle7? Here is the v1 version of the control file:
> LOAD DATA
> INFILE "ACS.DBF" FIXED 573
> APPEND
> INTO TABLE ACS
> (STANDARD POSITION(2:17) CHAR,
> IN_DATE POSITION(18:25) CHAR,
> TIME POSITION(26:33) CHAR)
>
> Please note that in this dbf file there is some header information which
> SQL*loader seemed to "know" was header info and did not
> load it into the table. Sqlloader v2 incorrectly tries to load this info into
> the table!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Mar 15 1999 - 17:15:13 CST