Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Any Ideas on this SQL*Loader Puzzle

Any Ideas on this SQL*Loader Puzzle

From: IIFThen <msessions_at_aldensys.com>
Date: Tue, 13 Jul 1999 12:42:42 -0500
Message-ID: <uQKi3.5989$iA1.28366@news4.mia>

From: IIFThen <msessions_at_aldensys.com>
Subject: Re: SQL Loader 524 Error: How to Prevent? Date: Tuesday, July 13, 1999 7:55 AM

Well...SQL*Loader says all records loaded correctly but when I query the table for these records it returns a count of 0. Try putting an eof character or any character at the end of your data file(i'm using an external one) and see if you can generate a nonzero count when you query the Oracle table. I'd like to know if I'm doing something crazy. FYI: SQL*Loader seems to handle partial records anywhere but the last line of the file.

BTW: The data file that I'm loading is being ftp'ed over to a server and I'm automatically running the SQL*Loader program against it. Therefore, I need for SQL*Loader to reject all partial records especially on the last line which I suspect is preventing my records from "actually" being loaded.

Thanks!

IIFThen

Mark G <someone_at_hot> wrote in message news:378af1e8.0_at_145.227.194.253...
> I had this a few times.
> The problem is with the end of file so all records before that should be
> loaded ok (well, it loaded all for me).
> I once was told that make sure a carriage return is at the end of your
file
> so sql*loader knows what the last record is. Also a carriage return at
the
> end of your control file.
>
> Try it and see.
>
> M
>
> IIFThen wrote in message ...
> >Hello. I'm loading Oracle 8 db with variable length records. How can I
> >prevent the following error from happening if the datafile(aithwsub.data)
> >has junk on a record like eof character, etc:
> >
> >SQL*Loader-524: Partial record found at end of datafile (aithwsub.dat)
> >
> >Is this even a problem? Will the good records be loaded and the bad ones
> >discarded? I looked through the SQL reference manual and nothing jumped
out
> >at me as an obvious solution.
> >
> >Thanks!
> >
> >Michael
> >
> >
>
>
Received on Tue Jul 13 1999 - 12:42:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US