Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader
As well as I know, you can not use SQl Loader if there is data in the
table. Is that right? If that is the case, is there any other way of
loading flat files into tables that already has some records?
The last question: Is SQl loader faster than sending individual sql statements from a CGI script? If yes, how much faster?
Thanks
Bulent Gumus
Software Engineer
OnBoard Software Inc.
In article <378A4981.23F21920_at_boyne.u-net.com>,
John Griffin <jgriffin_at_boyne.u-net.com> wrote:
> Don't worry its not a problem. All the good records will be loaded
and the
> dodgy ones rejected. You can verify this by checking the log file
which will
> be generated in the same directory as the control file by default.
>
> You can set SQL*Loader up to keep loading until a certain number of
errors
> occur ( I think this is 50 by default). If you only have one or two
dodgy
> records at the end of the file you will not hit this limit. Even if
you did
> you could increase the limit.
>
> Everything is detailed quite well in the manual.
>
> IIFThen wrote:
>
> > 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
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jul 12 1999 - 17:01:57 CDT