Home -> Usenet -> comp.databases.oracle -> Deletes in Oracle 7

Deletes in Oracle 7

From: Gary Mazzone <cgmazone_at_concentric.net>
Date: 1996/10/05
Message-ID: <32564F6D.53DE_at_concentric.net>#1/1 







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.
Received on Sat Oct 05 1996 - 00:00:00 CEST












Original text of this message