loader

From: <savula_at_my-deja.com>
Date: Mon, 18 Oct 1999 06:58:50 GMT
Message-ID: <7uegf7$1p6$1_at_nnrp1.deja.com>

[Quoted] 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:

[Quoted] 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. Received on Mon Oct 18 1999 - 08:58:50 CEST