create user grandmother identified by suckeggs;
select default_tablespace,temporary_tablespace from user_users
where username='GRANDMOTHER';
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
news:5atifvs23kg77r7ke8k48js52n0740aubl_at_4ax.com...
> Suppose you create a user and no default tablespace and no temporary
> tablespace are specified for the user.
> The DB does have a default tablespace and a default temporary
> tablespace.
> Where will the user's objects be stored?
> Where will the user's sort segments be stores?
>
> Thanks
>
>
Received on Wed Jun 25 2003 - 05:47:48 CDT
