Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL*Loader error
Message
 
 
To
21/03/2000 18:13:46
General information
Forum:
Oracle
Category:
Troubleshooting
Miscellaneous
Thread ID:
00348646
Message ID:
00348820
Views:
17
Just a WAG here, but it sounds like one of the records in the DAT file does not have enough delimited fields to meet the field list in the CTL file. If this is a large DAT file, you might try creating a cursor [or table] in VFP, do an append from delimited. Then do a copy to delimited. This should get enough commas into the DAT file so every record meets the CTL field list definitions.

>I am trying to import data with sqlldr80, and keep getting the following:
>SQL*Loader-524: partial record found at end of datafile (g:\~\load_docs.ctl)
>
>a) thats not the data file, ok, go to b
>b) all records appear to be present, each with all 15 fields
>The provided documentation say NOTHING about the error, in fact I can find no listing of SQLLoader errors anywhere. As far as I can tell there is no problem with the ctl file (this is the first time I've tried this)
>I get the same thing with sqlldr80 uid/pwd control=load_docs.ctl as I do with parfile=load_doc.par
>HELP!!!
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform