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