SQL Loader Error Message [message #368224] |
Fri, 06 October 2000 05:18 |
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 |
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 |
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 |
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 |
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 |
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 #512060 is a reply to message #512054] |
Thu, 16 June 2011 14:28 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|