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.
My advice is write a PL/SQL block and commits the transactions for every 250 (or so).

AMARENDRA B NETTEM
WHITTMAN-HART CORPORATION
CHICAGO.
http://www.iit.edu/~nettama Received on Sat Oct 05 1996 - 00:00:00 CEST