Re: SQL Loader

From: Ruud de Koter <ruud_dekoter_at_hp.com>
Date: Wed, 14 Jul 1999 08:58:46 +0200
Message-ID: <378C3526.FCED1A5A@hp.com>

Hi Bulent,

Two tentative answers:

bgumus_at_my-deja.com wrote:
>
> 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?

No, this is not true. You can load data into tables that already contain rows. There is a keyword, or in fact a set of keywords to specify whether your SQLLoader action is a 'REPLACE', 'APPEND', 'INSERT' or 'TRUNCATE'. Your Oracle Server Utilities manual can provide you with all detials.

>
> The last question: Is SQl loader faster than sending individual sql
> statements from a CGI script? If yes, how much faster?

SQLLOader is pretty fast, way faster than individual SQL statements. I think it's even orders of magnitude...

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

Ruud de Koter                    HP OpenView Software Business Unit
Senior Software Engineer         IT Service Management Operation
Telephone: +31 (20) 514 15 89    Van Diemenstraat 200  
Telefax  : +31 (2) 514 15 90     PO Box 831
Telnet   : 547 - 1589            1000 AV  Amsterdam, the Netherlands

Email : ruud_dekoter_at_hp.com

internet: http://www.openview.hp.com/itsm

          http://www.openview.hp.com/assetview

intranet: http://ovweb.bbn.hp.com/itservicemanager

--------------------------------------------------------------------------------------

Received on Wed Jul 14 1999 - 01:58:46 CDT