Re: Rollback segment question!!!

From: River Chan <wychan_at_vol.net>
Date: Tue, 26 Oct 1999 21:00:25 +0800
Message-ID: <3815A5E9.6CC38933@vol.net>

Assume your insert statement is executed in SQL*Plus. 1. Create a big rollback segment "Big_R01". 2. type the following command at the begining of a transaction (just after a commit or rollback):

set transaction use rollback segment Big_R01; 3. run your insert statement.

Thanks for any advice,
River Chan
riverchan_at_netscape.net

david_petit_at_yahoo.com wrote:

> Hello all,
>
> I want to insert large amount of data to Oracle table by using SQL
> statmenet (one copy SQL statment). However, I find that the rollback
> segment is not large enough. I want to create another rollback segment
> (large size), do the transaction, then drop the rollback segment. Is it
> possible? If yes, how can I do that? (I don't want to increase the size
> of existing rollback segment)
>
> Thanks,
> David
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 08:00:25 CDT