Re: RollBack TableSpaces

Although you can't assign the rollback TABLESPACE directly, you certainly can assign the rollback SEGMENT:

  SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment_name ;

As the FIRST line of code in your your program. See the Oracle7 Server SQL reference.

Regards,

In article <4v0mdt$jje2_at_red.interact.net.au>, grant_at_towersoft.com.au says...
>
>kdonovan_at_edgewater.com (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 ?
>
>As mentioned, you can't allocate a rollback segment to a user. You
>can cheat, however, and take all the other rollback segments offline
>(except the system one). This leaves only your rollback segment to be
>used. I use this technique sometimes when I'm the only user logged
>on, and I'm performing ridiculous data manipulation, but it is not of
>great use in a general day-to-day environment.
>
>Ciao
>Fuzzy
>:-)
>
>
Received on Fri Aug 16 1996 - 00:00:00 CEST