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: insert many records in short time

Re: insert many records in short time

From: Pat Boivin <lori.pat_at_ns.sympatico.ca>
Date: 2000/05/01
Message-ID: <390E160C.F6D2C2FE@ns.sympatico.ca>#1/1 






If you have multiple CPUs you can do parallel DML, to spread the load.



Regards,



Pat.



Shylasri Thirunagari wrote:



> I want to insert data from a partitioned table(300 million rows) to

> temporary non-partitioned table in short time. Table has just three

> number columns. No indexes, or constraints on the temporary table. Does

> somebody know any solutions.

>

> Oracle version 8.0.4 on Sun5.6.

>

> Regards,

> Shyla

Received on Mon May 01 2000 - 00:00:00 CDT












Original text of this message













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