Re: Problems deleting rows on Oracle
From: Aznable <termy_at_blunet.it>
Date: Fri, 11 May 2001 20:31:35 +0200
Message-ID: <3AFC3007.4A7A9863_at_blunet.it>
Date: Fri, 11 May 2001 20:31:35 +0200
Message-ID: <3AFC3007.4A7A9863_at_blunet.it>
> 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 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
> rollback segment anymore.
>
delete from table where <condition> and rownum < 400000;
repeat this statement until u get 0 rows deleted Received on Fri May 11 2001 - 20:31:35 CEST