Re: Rollback segments & Transactions

Paul Taylor wrote:
>
> Hi
>
> I have the following problem, can anyone help?
>
> We are trying to delete the contents of a tables, but it is quite large
> so therefore the rollback segment is either not large enough or I
> require some additional rollback segments.
>

Paul,

If the goal is to delete the content of a large table you can do this SQL> delete from large_table where rownum < 100; SQL> commit;

Keep repeat this until all rows are deleted.

Bob Received on Fri May 10 1996 - 00:00:00 CEST