Re: Assignment of undo tablespace to new user

On Wed, 21 May 2003 22:08:57 -0700, Daniel Morgan <damorgan_at_exxesolutions.com> wrote:

>Peter wrote:
>
>> Suppose you have an undo tablespace in use right now and then you
>> create a new user and you assign the user to an undo tablespace(on
>> Oracle9i) which is not currently in use. Will Oracle complain about it
>> or will it just assign the user to use system undo segments?
>>
>> Thanks
>
>You don't assign users to UNDO any more than you do to ROLLBACK. The
>create user syntax is:
>
>CREATE USER <user_name>
>IDENTIFIED BY <password>
>DEFAULT TABLESPACE <tablespace_name>
>TEMPORARY TABLESPACE <temp_tablespace_name>
>QUOTA ....
>
>No mention of undo or rollback. There can only be a single undo tablespace
>in 9i.

You can actually have more than one undo tablespace that is in use in Oracle 9i. You set it with parameter undo_tablespace=undotbs in your init file. But only one can be in use at any time. Received on Thu May 22 2003 - 13:21:09 CDT