Re: SQL Loader

SQL*Loader supports adding data to tables. It is by default in INSERT mode which will halt the process if data exists. Other modes are:

Append - Add data to the table
Delete - Deletes the table before inserting Truncate - Truncates the table before inserting.

You just need to add one of the other 3 modes to the control file .......HAROLD
bgumus_at_my-deja.com wrote in message <7mdoke$ju$1_at_nnrp1.deja.com>...
>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 Wed Jul 14 1999 - 05:54:05 CEST