I have a xls sheet with columns
Country Country_code Security_domain Locale Currency
---------------------------------------------------
ALGERIA AO EMEA English AlgerianDinar
AUSTRALIA AU APAC English AustraliaDollar
...
The .ctl file is:
LOAD DATA
INFILE 'C:\Boniva Views\INSERT INTO\Country-Currency-Region-Locale.Xls'
REPLACE
INTO TABLE mapping_countries_test
FIELDS TERMINATED BY ''
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
country "LTRIM(RTRIM
country))",
country_code "LTRIM(RTRIM
country_code))",
security_domain "LTRIM(RTRIM
security_domain))" ,
locale "LTRIM(RTRIM
locale))" ,
currency "LTRIM(RTRIM
currency))" ,
currency_short_name "LTRIM(RTRIM
currency_short_name))"
)
I'm getting error
Record 1: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length
Record 4: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length..
Field in data file exceeds maximum length
Record 1818: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY_CODE.
Field in data file exceeds maximum length
Record 1819: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length..
Any help..I'm using sqlldr for the first time.. I need your help.
FOR more then 50 COLUMNS..
Country Country_code Security_domain Locale Currency
---------------------------------------------------
ALGERIA AO EMEA English AlgerianDinar
AUSTRALIA AU APAC English AustraliaDollar
...
The .ctl file is:
LOAD DATA
INFILE 'C:\Boniva Views\INSERT INTO\Country-Currency-Region-Locale.Xls'
REPLACE
INTO TABLE mapping_countries_test
FIELDS TERMINATED BY ''
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
country "LTRIM(RTRIM
country_code "LTRIM(RTRIM
security_domain "LTRIM(RTRIM
locale "LTRIM(RTRIM
currency "LTRIM(RTRIM
currency_short_name "LTRIM(RTRIM
)
I'm getting error
Record 1: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length
Record 4: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length..
Field in data file exceeds maximum length
Record 1818: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY_CODE.
Field in data file exceeds maximum length
Record 1819: Rejected - Error on table MAPPING_COUNTRIES_TEST, column COUNTRY.
Field in data file exceeds maximum length..
Any help..I'm using sqlldr for the first time.. I need your help.
FOR more then 50 COLUMNS..