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

insert many records in short time

From: Shylasri Thirunagari <x00shyla_at_ti.com>
Date: 2000/04/30
Message-ID: <390CCB20.8166BC43@ti.com>#1/1 






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 Sun Apr 30 2000 - 00:00:00 CDT












Original text of this message













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