Re: Assignment of undo tablespace to new user

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.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)