Re: Default tablespace for a suer

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ef97dd5$0$18490$ed9e5944_at_reading.news.pipex.net>...

And the winner is ... SYSTEM TABLESPACE!

Dusan

> 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 - 10:18:28 CDT