Home » RDBMS Server » Server Utilities » SQL Loader - problem loading data from csv files
SQL Loader - problem loading data from csv files [message #249996] Fri, 06 July 2007 13:19 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi,

I am trying to load data from flat "|" delimited file to oracle table. Getting the following error in doing this:

Record 1: Rejected - Error on table SGT.HISTORY, column TIMESTAMP_V2R4.
ORA-01722: invalid number

No row is loaded.

My input format data is as below:
7342|0|0|900142181
9217|0|0|900241894
1757|905|0|900270301
4393|0|0|900743093
and control file is :

LOAD DATA
INFILE 'history.txt'
INTO TABLE sgt.HISTORY
FIELDS TERMINATED BY '|'
trailing nullcols
(COUNT_INSTANCE_ID,VALUE1,VALUE2,TIMESTAMP_V2R4)

Kindly help!

Thanks

[Updated on: Fri, 06 July 2007 13:20]

Report message to a moderator

Re: SQL Loader - problem loading data from csv files [message #249997 is a reply to message #249996] Fri, 06 July 2007 13:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the DESC of your table is?
And the Oracle version is? (4 decimals)
And did you check there is no unprintable character in your file.

Btw, there is a Server Utilities forum for question on Utilities.

Regards
Michel
Previous Topic: Exporting User Schema
Next Topic: Partitioning the table
Goto Forum:
  


Current Time: Sat Dec 03 15:53:09 CST 2016

Total time taken to generate the page: 0.09636 seconds