Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help on this load question
I would not concur in the assesment that direct-path SQLLLOADs are not
safe to use in production systems -- I work for a large financial
services company and we SQLLOAD millions of rows a month from our VRU
databases... we never have any issues with that component of the
system.
Nathan
On Sun, 17 Oct 1999 16:42:55 GMT, sudha_kar_at_hotmail.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:
>
>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 Wed Oct 20 1999 - 20:33:36 CDT