Re: Bulk insert/delete

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Wed, 31 May 2006 16:34:21 +0400
Message-ID: <e5k2gf$2v4g$1@hypnos.nordnet.ru>

"GL" <georlevin_at_aim.com> wrote in message news:1149077125.154658.29110_at_i40g2000cwc.googlegroups.com...
>
> Thank you Vladimir ,
> The logic behind this: the table1 has 80-200 mil or rows, and it has 10
> different categories. clean up should process these categories in
> different way.,i.e data should be sum,avg,max etc inside the given
> category in the certain data ranges.These set of data should be
> kept.The avarage amount of data to keep around 2-5 mil rows.
> And COMMIT should happened only when category is done and then will
> proceed to next, so on and so on
>

Well, I still fail to see why you are trying to use PL/SQL for this and why possible solutions I suggested do not fit. If you can come up with a query that will select only data you need to keep, either of those solutions will do.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com

Received on Wed May 31 2006 - 07:34:21 CDT