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

Home -> Community -> Usenet -> c.d.o.misc -> bulk copy into a table...??

bulk copy into a table...??

From: Tim <taucoin_at_valenciasystems.com>
Date: 7 Oct 1998 15:57:18 GMT
Message-ID: <6vg30u$klg$1@comet3.magicnet.net>


Hi, I've got a Java application that inserts several thousand records into a table every couple of minutes. I've heard there is a way to bulk copy a large number of records into a table, but I haven't been able to find out how to do it. If there isn't a way, is there a way to insert the records one at a time into a temporary table and then bulk copy the temp table into the real one? Would using the temp table be more efficient/faster than inserting each record individually?

Thanks for your time and your generosity in giving a response

Tim Aucoin
Valencia Systems, Inc. Received on Wed Oct 07 1998 - 10:57:18 CDT

Original text of this message

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