Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Default tablespace for a suer

Re: Default tablespace for a suer

From: David Fitzjarrell <oratune_at_msn.com>
Date: 25 Jun 2003 09:52:46 -0700
Message-ID: <32d39fb1.0306250852.54bbcb@posting.google.com>


That should show you that SYSTEM is the default tablespace and the temporary tablespace ... a scary proposition.

David Fitzjarrell

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ef97dd5$0$18490$ed9e5944_at_reading.news.pipex.net>...
> 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 - 11:52:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US