Home » RDBMS Server » Server Utilities » SQL Loader Error Message
SQL Loader Error Message [message #368224] Fri, 06 October 2000 05:18 Go to next message
Chella
Messages: 25
Registered: September 2000
Junior Member
When I try to load a .TXT file into an Oracle table, the following message is given at the command prompt;

SQL*Loader-524: partial record found at end of datafile

and the load is not successful. The control file is as follows;

Load Data
INFILE 'c:\bsp\ledlsubj.txt'
APPEND
INTO TABLE tblSubjectiveCode
(
SUBJ_DESCR POSITION(01:40),
ENTITY POSITION(42:42),
FUND_CTRL POSITION(44:44),
L_SUBJ_CODE POSITION(46:49),
L_SUBJ_KEY POSITION(51:60),
M_SUBJ_CODE POSITION(62:65),
STOP_IND POSITION(67:67),
XSERVICE POSITION(69:69),
YR_LETTER POSITION(71:71)
)

Could the .TXT file causing any problems ? Suggestions appreciated. TIA
Re: SQL Loader Error Message [message #368225 is a reply to message #368224] Fri, 06 October 2000 07:19 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi Chella,

You need a blank new line at the bottom of
cotrol file and datafile.
In your case it says datafile.
Hence append a new empty line at the bottom of the txt file.

Bala.
Re: SQL Loader Error Message [message #368226 is a reply to message #368224] Fri, 06 October 2000 08:12 Go to previous messageGo to next message
Chella
Messages: 25
Registered: September 2000
Junior Member
Hi Bala

Thank U. It worked. Why does it require a blank line at the end of either the control or data file or both files ? This datafile is going to be extracted from mainframe everyday and loaded into the Oracle table. This will be a scheduled job and I am just wondering whether any absense of a blank line is going to cause any future problems. Again, thank U for your help

Chella
Re: SQL Loader Error Message [message #368227 is a reply to message #368224] Fri, 06 October 2000 09:23 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi Chella......

Sqlloader uses the new line charecter as termination point. So at the end of the data file
you need a new line to terminate your last record,
other wise it will think the record is partial.

For your batch you can have
a file with empty line and append it to the datafile every time before load.

C> type empty_line.txt >> data.txt
C> sqlldr80 ...........................

Thanks
Bala
Re: SQL Loader Error Message [message #368229 is a reply to message #368224] Fri, 06 October 2000 10:23 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
I know a little, still a lot to learn.
I have been working on oracle products for the past 4 yrs or so.....

Since you are beginner, i would suggest you to take oracle OCP certification tests.
That will make you to learn all five major sections of oracle database server(from sql to networking).
visit http://education.oracle.com/certification
for more details.........

Good Luck
Bala.
Re: SQL Loader Error Message [message #368230 is a reply to message #368224] Fri, 06 October 2000 10:37 Go to previous messageGo to next message
Chella
Messages: 25
Registered: September 2000
Junior Member
Hi

I am actually being trained to be an Oracle Developer (haven't done the OCP, would like to at some point though) but I am at the moment the analyst for our first Oracle Project and I have to sort out few DB side issues as well. So, there U are. Anyway, have a nice weekend. Will ask you more questions if in doubt!

Chella

Chella
Re: SQL Loader Error Message [message #512054 is a reply to message #368229] Thu, 16 June 2011 14:17 Go to previous messageGo to next message
mallikarjuna
Messages: 1
Registered: June 2011
Location: hyderabad
Junior Member
Hai Bala,

I am pallaki.I am new to oracle apps.I got the same error. please explain me how to add new line to control file and data file
Re: SQL Loader Error Message [message #512060 is a reply to message #512054] Thu, 16 June 2011 14:28 Go to previous message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think it is still there waiting on this topic after more than 10 years?
Explain in details what is your problem and Oracle version BUT create a new topic for that and let the zombie rest in peace.

Regards
Michel
Previous Topic: Send email after the export done (successfully without error and with error )
Next Topic: Data Pump expdp to ASM daily
Goto Forum:
  


Current Time: Wed Dec 01 21:48:12 CST 2021