Re: Default tablespace for a suer

There is only one for the default temp tablespace. If you look at the docs
(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_15a.htm#2079107), you will see how to set a default temporary tablespace, but there is no mention of how to set the default data tablespace.

HTH,
Brian

Tanel Poder wrote:
>
> No, I don't think there's a system wide default for data tablespaces. Only
> for temp.
>
> In PROPS$ there is only DEFAULT_TEMP_TABLESPACE record, nothing for data.
> The syntax also supports setting default temp ts. The winner is system.
>
> SQL> select value$ from props$ where name like 'DEFAULT%';
>
> VALUE$
> ----------------------------------------------------------
> TEMP
>
> SQL> create user x identified by x;
>
> User created.
>
> SQL> select default_tablespace, temporary_tablespace from dba_users where
> username = 'X';
>
> DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
> ------------------------------ ------------------------------
> SYSTEM TEMP
>
> Tanel.
>
> "Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
> news:3EF9C134.FA1E0C15_at_telusplanet.net...
> > Dusan Bolek wrote:
> >
> > > "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!
> >
> > Actually - it depends!
> >
> > Latest versions allow system wide defaults - and the OP did specify that
> these were set.
> >
> >
> >

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"