Home » RDBMS Server » Server Utilities » another problem in sqlloader
another problem in sqlloader [message #69122] Fri, 02 November 2001 13:29 Go to next message
w j
Messages: 4
Registered: November 2001
Junior Member
the data is:
31, 1, 0.0, 0.0, 0.0, 0.23002, gamma1, 000, 1
31, 1, 0.0, 0.0, 0.0, 0.98073, gamma2, 000, 2
......

________________________________________________
and the control file is:
LOAD data
infile 'testdata.dat'
append
INTO table test
fields terminated by ","
trailing nullcols
(tid, codea, codeb, codec, coded, codee, codef, codeg, codeh)

___________________________________________
sqlloader told me that 27 records inserted,
but when i select * from the table, I found that
just only one record in table: just the first line
in data file: 31, 1, 0.0, 0.0, 0.0, 0.23002, gamma1, 000, 1

could you tell me why? thank you so much!!!!

----------------------------------------------------------------------
Re: another problem in sqlloader [message #69123 is a reply to message #69122] Sat, 03 November 2001 04:12 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
open log file and you will get more information why records rejected. ( it could be primary key problem or data length of field is not enough)

SURESH

----------------------------------------------------------------------
Previous Topic: sqlloader load error
Next Topic: Re: oracle 9i and Linux !!!!
Goto Forum:
  


Current Time: Fri Mar 29 03:16:49 CDT 2024