Re: Deletes in Oracle 7

Gary Mazzone 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.

Perhaps you can disable some foreign-key constraints before the delete.

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)