Oracle data load

From: <sudha_kar_at_hotmail.com>
Date: Sun, 17 Oct 1999 16:41:28 GMT
Message-ID: <7ucu7n$3e4$1@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 Sun Oct 17 1999 - 11:41:28 CDT