Re: Please help on this load question

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Mon, 18 Oct 1999 09:26:38 GMT
Message-ID: <iJBO3.22$p%6.1551747@France.EU.net>

Hi sudha !

You can merge your file in order to import data from only one filen if possible.

Then use SQL*Loader !

Regards.

<sudha_kar_at_hotmail.com> a écrit dans le message : 7ucuad$3e9$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 - 04:26:38 CDT