Re: RollBack TableSpaces

Kevin J. Donovan wrote:
>
> Help !
>
> Im having some minor problems here; I have an oracle database that I
> created, within this DB there is a default rollback tablespace created
> by Oracle as well a RollBack segment that I have created. How do I
> explicitly state for users in a database to use a particular rollback
> table space in lieu of the default rollback tablespace ?
>
> Kevin Donovan kdonovan_at_edgewater.com
> Edgewater Technology (617) 246-3343 voice
> 20 Harvard Mill Square (617) 246-5903 fax
> Wakefield, MA 01880

You can do that by specifying the following for each transaction:

commit; /* must do this first */
set transaction use rollback segment XXXXXXXX; /* XXXXXXXX is your RBS */
alter rollback segment XXXXXXXX offline; /* so nobody else uses it */ /* execute your SQL here */
commit;
alter rollback segment XXXXXXXX online; /* available for all again */

Greg Grooms
PRC
St. Louis Received on Thu Aug 15 1996 - 00:00:00 CEST