Re: Assignment of undo tablespace to new user

Peter wrote:

> 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.

Thanks. I could have been clearer than I was.

--
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)