Re: SQL Loader 524 Error: How to Prevent?

Se responses below:

John Griffin <jgriffin_at_boyne.u-net.com> wrote in message news: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.
>
> 1. Please verify that the table name in the control file is the same as
the
> table you are checking with the query

Check.

> 2. 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

Check.
> 3. Verify that the log file you are looking at has the correct timestamp
and it
> is the correct log file

Check.
> 4. If you check all of these and everything appears fine try using the
parameter
> COMMIT_DISCONTINUED=TRUE
What is this and where does it go in my control file below?:

• Requires CR/LF on last line of control file.

OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)
UNRECOVERABLE
LOAD DATA
INFILE 'aithw.dat'
TRUNCATE
INTO TABLE AIT.AITHW ("STATE" POSITION (01:02) CHAR,

"AREA" POSITION (03:09) CHAR,
"IMPORT_DAT" POSITION (10:15) CHAR,
"CPR" POSITION (16:21) CHAR,
"FRC" POSITION (25:29) CHAR,
"FLOOR" POSITION (30:31) CHAR,
"FRAME_ID" POSITION (32:40) CHAR,
"YR" POSITION (41:42) CHAR,
"QTY" POSITION (43:50) CHAR,
"MAT_COST" POSITION (51:62) CHAR,
"INPL_COST" POSITION (63:74) CHAR,
"ECN" POSITION (75:79) CHAR,
"ECN_INPL" POSITION (80:91) CHAR,
"BASIC" POSITION (94:105) CHAR,
"PART" POSITION (106:132) CHAR)

>
>
>
> IIFThen wrote:
>
> > 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 Wed Jul 14 1999 - 12:27:27 CDT