Re: RollBack TableSpaces
Date: 1996/08/16
Message-ID: <4v0mdt$jje2_at_red.interact.net.au>#1/1
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