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 -> Re: SQL*Loader Limitation?

Re: SQL*Loader Limitation?

From: geraldine grubb <ggrubb_at_indiana.edu>
Date: Mon, 19 Jul 1999 10:19:11 -0500
Message-ID: <379341EF.93E4759F@indiana.edu>


Same answer here - add a carriage return at the end of the control file. I had the same problem and it fixed it.

--gg

dogbert_at_myremarq.com wrote:

> Just a quick stab at your problem: make sure you have a carriage return at
> the end of the last line of your .ctl file.
>
> IIFThen <msessions_at_aldensys.com> wrote in message
> news:Jkkj3.9517$Tl3.72957_at_news3.mia...
> > Can SQL*Loader (used on NT server) handle partial records at the END of a
> > data file?
> >
> > SQL*Loader log file reports records successfully added but when I query
> the
> > data with SQL Worksheet it returns a count of 0. Can anyone out there try
> > inserting a character at the end of their datafile and then run
> SQL*Loader
> > against it. Then query to see if ALL non-partial records were loaded. For
> > me, 1) SQL*Loader reports Error 524: Partial records found at the end of
> the
> > data file, 2) SQL*Loader log file says that all records were successfully
> > loaded. 3) When I query the table, no records are there.
> >
> > I've already checked:
> >
> > * I looking at the right SQL*Loader file(timestamp, etc.)
> > * I used same schema parameters for both SQL*Loader and SQL Worksheet.
> >
> > I'm at a dead end on this one. I would appreciate any help.
> >
> > IIFThen
> >
> >
Received on Mon Jul 19 1999 - 10:19:11 CDT

Original text of this message

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