Re: process takes a long- BULK COLLECT

From: <>
Date: Wed, 13 Aug 2008 21:09:46 +0200
Message-ID: <>

On Wed, 13 Aug 2008 10:17:49 -0700 (PDT), EliasFigueroa <> wrote:

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

As posted before the BULK collect is fully redundant, and a INSERT SELECT will do.
Did you read that response?
If so, can you explain why you can't implement it?

Sybrand Bakker
Senior Oracle DBA
Received on Wed Aug 13 2008 - 14:09:46 CDT

Original text of this message