Re: Deletes in Oracle 7

Hi Gary,

i can confirm: deletes are -very- slow.

You should really consider this (if possible):

create mgevents_new as select * from mgevents where bdate_time >= '1-jan-96'; create indexes ...
drop table mgevents;
rename mgevents_new to mgevents;

If rollback-segemnts are your problem try to do:

delete from .... where ... and rownum < 5000; commit;
and again until no more deletes are left.

Kind regards,

Toni

In article <32564F6D.53DE_at_concentric.net>, Gary Mazzone <cgmazone_at_concentric.net> wrote:

> Help
>
> I am trying to delete about 65000 records from a database running on
> SCO UNix Oracle 7.1. The deletes will go but I have to keep the number
> of records below 20,000 and 14,000 records take about 2:30 hrs. The
> table has a primary key on two fields, badge and bdate_time. I am doing
> the delete wilth the following statement.
>
> delete from mgevents where bdate_time < '1-jan-96'
>
> this is the 65,000 record set. any help is greatly appricated. Please
> replay to mazzogp_at_naesco.com
>
> Thanks for any help.
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |