-
Hi,
I 'm tried to populate an oracle table from an export I got from oracle.
My control file:
LOAD DATA
INFILE 'c:\countries.dat'
INTO TABLE countries
FIELDS TERMINATED BY ','
(country_code,
country,
currency_code,
currency_name ,
currency_symbol )
My data file:
PH,Philippines,560,Peso,
PL,Poland,378,Zloty,
PT,Portugal,269,Escudo,Esc
But when I run sqlldr, I get the following error:
Record 1: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 3: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)
Can you tell me how to solve this?
thanks a lot
pst
-
Try this
LOAD DATA
INFILE 'c:\countries.dat'
INTO TABLE countries
FIELDS TERMINATED BY ','
(country_code NULLIF country_code=BLANKS,
country NULLIF country=BLANKS,
currency_code NULLIF currency_code=BLANKS,
currency_name NULLIF currency_name =BLANKS,
currency_symbol NULLIF currency_symbol =BLANKS)
-
add one more comma to your ist three line you have five filed and value you are entering is four
-
use TRAILING NULLCOLS.
Sanjay