Database Utilities (MOSC)

MOSC Banner

sqlldr control file -- what's wrong?

edited Oct 6, 2015 6:37PM in Database Utilities (MOSC) 1 commentAnswered ✓

Enterprise Edition 11gR2

Trying to load data from a csv file created by sqlcli.

Records are variable length, character fields delimited by '"'.

all fields terminated by ','

Below is an example of my control file:

LOAD DATA

infile load.txt

badfile load.bad

discardfile load.dis

into table owner.table_name

truncate

fields terminated by ',' optionally enclosed by '"'

(

SAK_KEY integer external

,LOCATDATE integer external

,LOCATTIME integer external

,PARTITION char(2)

,PAYERNAME varchar(20)

,PAYERID varchar(10))

Sample of data

432434356,20140901,102044,"01","SomeDumbPayer","XXXX"

Error received:

value used for ROWS parameter changed from 64 to 56

Record 1: Rejected - Error on table owner.table_name, column PAYERNAME.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center