Re: Problems deleting rows on Oracle
From: steve <E_at_E.COM>
Date: Thu, 10 May 2001 09:31:43 +0800
Message-ID: <1et6qec.1hcsz1a2dxl6gN%E_at_E.COM>
Date: Thu, 10 May 2001 09:31:43 +0800
Message-ID: <1et6qec.1hcsz1a2dxl6gN%E_at_E.COM>
Hi,
that's not a good idea.
just delete smaller lots with a commit after each batch. either by date or some other key.
steve
<bkanneg_at_newsguy.com> 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 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.
>
> Thanks,
> Brian
Received on Thu May 10 2001 - 03:31:43 CEST