-
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 <NT>
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.
with regards
Prasanna S
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|