sql loader loading less fields than columns

Question

For example, my input file looks like this

1;2;AAA;

and my database like this:

PK NUMBER,
C1 NUMBER,
C2 NUMBER,
C3 VARCHAR2

On my PK I have a sequence but I cannot use it in the .ctl file.

I am trying to use a ctl file like this: (separated by ";")

PK FILLER "function()", C1, C2, C3

Yet this fails, it jumps over the first value in the input file...so

@radshk RADU - Can you post your complete SQL*Loader control file? — Justin Cave
– Justin Cave, Commented Feb 1, 2012 at 18:12
@Justin LOAD DATA INFILE 'AlimentationFichier.data' BADFILE 'AlimentationFichierRejets.data' REPLACE INTO TABLE P4PCA2_PIVOT_CA FIELDS TERMINATED BY "||" ( NUM_IDGEN_ALL_EVT FILLER "fff()", CA_DAT_EVT "to_date(:CA_DAT_EVT,'YYYY-MM-DD')", CA_NUM_PSG_EVT , and on.. — Samson
– Samson, Commented Feb 2, 2012 at 8:52

Samson · Accepted Answer · 2012-02-02 10:28:13Z

1

The solution was to add TRAILING NULLCOLS to the loader and place the PK at the END so it considers it null and uses the sequence, and therefore not mix the fields order.

answered Feb 2, 2012 at 10:28

Samson

2,8317 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql loader loading less fields than columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related