-
hi
i'm having problem using sqlldr
here's what i did that gives me error >PARTIAL RECORD FOUND AT END OF DATAFILE<
load data
infile 'user.txt'
append
into table users
fields terminated by "|" trailing nullcols
(acctid, password)
C>sqqldr userid=uid/pwd,control=name of ctl
can anyone help me what's wrong and how can i load data to oracle table
thanks guys 4 help
-
Hi,
Make sure the last record in the datafile is complete and has the correct terminating character(s). Also, if fixed-length records are in use, verify that no record exceeds the platform-specific length for a single record.