SQL* copy command, you can set the arraysize and copycommit. I'm not sure if this will speed it up.
What about adding a query to an export file and using IMP/EXP, providing this is 8i.
MH
|
Results 1 to 10 of 23
Thread: Insert taking too much of time.Threaded View
|
Click Here to Expand Forum to Full Width |