Re: Problems deleting rows on Oracle
From: steve <E_at_E.COM>
Date: Tue, 22 May 2001 18:45:20 +0800
Message-ID: <1etadf6.1qcqpmsgvjva4N%E_at_E.COM>
> >
>
> delete from table where <condition> and rownum < 400000;
>
> repeat this statement until u get 0 rows deleted
Received on Tue May 22 2001 - 12:45:20 CEST
Date: Tue, 22 May 2001 18:45:20 +0800
Message-ID: <1etadf6.1qcqpmsgvjva4N%E_at_E.COM>
and how will this little gem help with the overflowing rollback logs?
Aznable <termy_at_blunet.it> wrote:
> > I am trying to use a delete query in Oracle to delete a large number of rows
> > from the database (> 430,000 rows). I keep running into a problem saying
>>the> > rollback segment anymore.
> > rollback segment is not large enough. Is there any way to delete these rows
> > without using a rollback segment? The DBA said he could not increase the
> >
>
> delete from table where <condition> and rownum < 400000;
>
> repeat this statement until u get 0 rows deleted
Received on Tue May 22 2001 - 12:45:20 CEST