Re: process takes a long- BULK COLLECT

From: <sybrandb_at_hccnet.nl>
Date: Wed, 13 Aug 2008 21:09:46 +0200
Message-ID: <u9c6a49i77lcmbpl4t662u138fg1qil43i@4ax.com>


On Wed, 13 Aug 2008 10:17:49 -0700 (PDT), EliasFigueroa <Eliasfimo_at_gmail.com> 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