Home » RDBMS Server » Server Utilities » sql*loader
sql*loader [message #70347] Fri, 31 May 2002 06:25 Go to next message
shankar
Messages: 29
Registered: January 2002
Junior Member
sir,
iam loading data from a dbf file into oracle 8i tables.
since the data cannot be directly loaded i had to convert the .dbf file into text file.while invoking the sql*loader iam facing error:partial record found at the end of file.it's common error.i have removed the control charecter at the end of file which is generated during saving file in foxpro.but still the error remains.do u have any soln.it's very urgent.i'll be very grateful if u kindly provide a soln.
Re: sql*loader [message #70348 is a reply to message #70347] Fri, 31 May 2002 06:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can you post the sample file?
Re: sql*loader [message #70350 is a reply to message #70347] Fri, 31 May 2002 07:26 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Try This,

Just press a return at the end of the
control file. This should work..

Cheers,
Sujit
Previous Topic: export in 9i :error
Next Topic: sqlldr with dates and times
Goto Forum:
  


Current Time: Wed Apr 24 23:02:13 CDT 2024