Re: Oracle data load

From: John Goodens <wootang_warrior_at_hotmail.com>
Date: Mon, 18 Oct 1999 23:05:33 +0200
Message-ID: <7ug23p$1sjp$1@nntp01.global.co.za>

I CONSTANTLY have problems with sqlldr on Linux, the Memory usage goes through the roof (378 Megs)
and the machine freezes.
Firstly I truncate the temporary table, then fill it using sqlldr with "replace into table_name" within the .ctl file

Any Ideas?

<sudha_kar_at_hotmail.com> wrote in message news:7ucu7n$3e4$1_at_nnrp1.deja.com...
> I want to load sets of 20,000 records each from 4000 different flat
> files into a table. I know conventional SQl load takes lot of time,
> Also, I am told it is not safe to use Direct SQL Load to production
> tables.
>
> So, could you please tell me what is the best way to get the data into
> the tables.
>
> The table has a composite primary key which should be enforced when I
> load.
>
>
> One way i tried was to load into a temporary table and then use:
>
> Insert into production_table select * from temp_table.
>
> Is this the best method or is there a faster approach.
>
> I want it to be as fast as possible.
>
> Please e-mail to sudha_kar_at_hotmail.com
>
> Thanks
> Sudhakar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 18 1999 - 16:05:33 CDT