We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL Loader -524 error

newtoperlpgm
newtoperlpgm asked
on
Medium Priority
527 Views
Last Modified: 2012-12-22
I am getting SQL*Loader-524:
partial record found at end of datafile
when trying to import data from a data file into an Oracle table using SQL Loader.  

There is nothing at the end of my file, there aren't any spaces of returns after my last column of data, anyone know how I can avoid this?
Thanks.
Comment
Watch Question

Commented:
Put a return after the last row.

Author

Commented:
That was the first thing I tried, but that did not work.  Any other suggestions?
Thanks!

Commented:
Try copy/pasting just the contents into a new file.  

Convert the file to unix format.

Make sure your syntax is 100% correct.  

Verify a known good file and compare it to yours.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Do you have trailing null columns set in the control file?

Can you post your controlfile and sample data that produces the error so we can reproduce the problem and provide a solution?

Author

Commented:
I do have trailing null columns set in the control file.

I believe it is having a problem with the % as data in one of the columns.
How to get around this?
Thanks.

BRCODE|RECT|LOG_DATE|SAM_TYPE|SAM_TA|SAM_BLDG
224044|0|04/25/2011 10:55|Air Sample|TA-0|AIrNet
BRCODE|RES_ID|ACT_UNIT|ERR_UNIT|LD_UNIT|LD|DET|ISO|ACT|ERROR
224044|3|Ci|%|Ci||FALSE|NONE||
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Can you post the controlfile?

I'll set up a test case on my database and provide working code or at least a fix.
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
Hmm actually it seems like quoting it is the oracle way.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.