Home » RDBMS Server » Server Utilities » loader loading only the first character (10.0 win xp)
loader loading only the first character [message #333969] Tue, 15 July 2008 01:27 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am trying to load the US states in my table (details (state varchar2(20)).

Here is my control file

load data 
infile 'd:\states.txt'
append
into table details(state)


The loader is just loading the first character from the two characters of the state names
eg A for Al, C for CT, D for DE.

Would you have any idea why it is not working the way it should?

(States list attached)
  • Attachment: states.txt
    (Size: 0.23KB, Downloaded 105 times)
Re: loader loading only the first character [message #334011 is a reply to message #333969] Tue, 15 July 2008 03:32 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you modify the control file to
into table details
  (state char terminated by whitespace)
Re: loader loading only the first character [message #334037 is a reply to message #334011] Tue, 15 July 2008 04:45 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member

yes..it is working fine now

Thanks
Previous Topic: Is it possible database backup tranfer to next version
Next Topic: Loading multiple tables from delimited file with SQL*Loader
Goto Forum:
  


Current Time: Thu Dec 08 06:12:02 CST 2016

Total time taken to generate the page: 0.18405 seconds