Re: Delete with lot of data in Oracle 7.3

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Fri, 26 Nov 1999 17:56:46 +0100
Message-ID: <383EBBCE.6950BC1@psi.de>

I know that you have Oracle 7.3.4. But maybe you ca upgrade to Oracle 8. In this case partition are helpfull. Try to organize your data in a way that all data you like to delete in one moment are in the same partition.

regards Jan Dieckmann

eric duchet wrote:
>
> 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 Fri Nov 26 1999 - 10:56:46 CST