Re: loader

savula_at_my-deja.com wrote:

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

Personally I would choose temp tables method and use complete column list for insert and select in the following line.

>
> 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.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Breno de Avellar Gomes
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342

Toll free fax and voice recorder from USA
1-888-EXCITE2  extension  291-303-8152

Outside USA (international fares apply)
1-917-463-3173