Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Delete with lot of data in Oracle 7.3

Delete with lot of data in Oracle 7.3

From: eric duchet <eric.duchet_at_free.Fr>
Date: Wed, 24 Nov 1999 22:36:17 GMT
Message-ID: <BLZ_3.944$hI2.3831873@nnrp2.proxad.net>


Hi,

I have on my database a table containing 50 000 000 rows. Every day I have to delete 1 000 000 rows to avoid the database to grow (the same number of rows are to this table in a day)

I use Oracle 7.3.4 on AIX

An Oracle Consultant told me that it is not realistic to delete so many rows.
What do You think about that ?
Otherwise, what dou You preconise.

Thanx. Received on Wed Nov 24 1999 - 16:36:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US