Re: process takes a long- BULK COLLECT

EliasFigueroa wrote:
> The loading process is very slow as optimize
> are 500000 records and takes 5 hours to insert in another table.

The demo code under BULK COLLECT and FORALL in Morgan's Library at www.psoug.org easily inserts 400,000 records/second on my laptop.

Try the demo code on your system and see how it performs. If there are issues then you need to look at operating system, init params, and storage infrastructure.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org