Re: SQL Loader

[Quoted] [Quoted] As well as I know, you can not use SQl Loader if there is data in the [Quoted] 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?

[Quoted] 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
[Quoted] 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 Tue Jul 13 1999 - 00:01:57 CEST