Re: Default tablespace for a suer

From: Tanel Poder <tanel_at_@peldik.com>
Date: Wed, 25 Jun 2003 21:12:02 +0300
Message-ID: <3ef9e604$1_1@news.estpak.ee>

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.
>
>
>
Received on Wed Jun 25 2003 - 13:12:02 CDT