Re: process takes a long- BULK COLLECT
Date: Wed, 13 Aug 2008 21:09:46 +0200
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 DBAReceived on Wed Aug 13 2008 - 14:09:46 CDT