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>
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 DBAReceived on Wed Aug 13 2008 - 14:09:46 CDT