Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql*loader error

Status
Not open for further replies.

syncdba

IS-IT--Management
Nov 28, 2005
206
US
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..






 
Hi,
What is the MAPPING_COUNTRIES_TEST table's structure?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Its
Country varchar2(90)
Country_Code varchar2(90)
security_Domain varchar2(90)
Locale varchar2(90)
Currency varchar2(90)
Currency_code varchar2(90)
 
May be a silly question, but is it an Excel spreadsheet that you are trying to load? As far as I know, SQL Loader has no facility for that (apologies if I'm behind the times here). You could save it as a .csv file and load that. In that case, you will need to alter the description to
Code:
fields terminated by ','
optionally enclosed by '"'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top