Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data load

Re: Oracle data load

From: <jdufour_at_my-deja.com>
Date: Mon, 18 Oct 1999 03:03:46 GMT
Message-ID: <7ue2md$pi1$1@nnrp1.deja.com>


Hello.

  1. Use parallel, direct for SQLLOAD into one (or more) temporary tables.
  2. The production table sounds like a candidate for partitioning. Consider it if you haven't already.
  3. Sort the input for the temporary tables by the primary key sequence of the production table before load.
  4. If feasible, run concurrent inserts from multiple sessions into the production table from the temporary table(s).

Lots of data to load (80M rows). Good luck.

jdufour_at_home.com

In article <7ucu7n$3e4$1_at_nnrp1.deja.com>,   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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 17 1999 - 22:03:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US