Re: SQL Loader 524 Error: How to Prevent?
Date: Tue, 13 Jul 1999 21:48:01 +0100
Message-ID: <378BA5FF.370762E1_at_boyne.u-net.com>
IF the SQL*load file says that it has written records to the table then I would believe it - it sounds like you are doing something wrong.
- Please verify that the table name in the control file is the same as the
table you are checking with the query
- Verify that you are using logging on to the same schema with SQL*loader as you are when running the query i.e. you are not running the query against another copy of the table in another schema
- Verify that the log file you are looking at has the correct timestamp and it
is the correct log file- If you check all of these and everything appears fine try using the parameter
COMMIT_DISCONTINUED=TRUE
> 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 - 22:48:01 CEST