Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> bulk copy into a table...??
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