Re: commit afer unable to extend rollback segment

From: Richard Hansen <hansenrd_at_BITEME_SPAMMERS_cadvision.com>
Date: 1997/10/21
Message-ID: <344d3f00.814764@news.cadvision.com>#1/1

On Tue, 21 Oct 1997 10:46:11 -0400, joseph_sumalbag_at_bose.com wrote:

>What I suggest for you to do is use the s
>"Set transaction use rollback
> segment BIGROLLBACKSEGMENTNAME"
>
>to use the larger rollback segment in your DB for your
>transaction, or maybe do a pl/sql procedure to break the
>transaction into smaller pieces .

On the other hand, if all you're doing is "DELETE FROM my_table" with no "WHERE" clause (you want to empty the table entirely), you can just truncate the table and don't have to worry about rollback segments at all.

---

Richard Hansen
hansenrd_at_BITEME_SPAMMERS_cadvision.com

To respond, remove BITEME_SPAMMERS_ from my address

---

Received on Tue Oct 21 1997 - 00:00:00 CDT