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

Oracle does not allow you designating a rollback tablespace for a user. Rollback tablespaces are shared by mutiple transactions from possibly mutiple users. But Oracle does allow users to specify a specific rollback segment for a given transaction.

-- 
Bo Lu
Senior Programmer/Analyst
Hospital and Clinical Informatics, U. of Utah
801-581-5964, bo.lu_at_hsc.utah.edu