Re: Error in Doc (Create user)?

From: Albert Albani <albanialbert_at_yahoo.de>
Date: 23 Aug 2004 01:27:57 -0700
Message-ID: <7c2ca73a.0408230027.27204356@posting.google.com>

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<41275c17$0$26982$626a14ce_at_news.free.fr>...
> "Albert Albani" <albanialbert_at_yahoo.de> a écrit dans le message de
> news:7c2ca73a.0408210603.77776161_at_posting.google.com...
> > Hello
> >
> > Oracle's documentation states
> >
> (http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_8003.htm#SQLRF01503)
> > "You cannot specify a locally managed tablespace, including an undo
> > tablespace, or a dictionary-managed temporary tablespace as a user's
> > default tablespace."
> >
> > However, it looks like I can do exactly that.
> >
> > Did I oversee something?
> >
> > Albert
>
> Can you post your test case?

Here it is. Delete_me's default tablespace will be users although the tablespace user is locally managed.

ALBERT_at_ora10> select * from v$version;

BANNER

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production

ALBERT_at_ora10> select tablespace_name,extent_management 2 from dba_tablespaces;

TABLESPACE_NAME                EXTENT_MAN
------------------------------ ----------
SYSTEM                         LOCAL
UNDOTBS1                       LOCAL
SYSAUX                         LOCAL
TEMP                           LOCAL
USERS                          LOCAL

ALBERT_at_ora10> create user delete_me
  2 identified by delete_me
  3 default tablespace users
  4 temporary tablespace temp;

User created.

ALBERT_at_ora10> select username, default_tablespace 2 from dba_users
3 where username like 'DE%';

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
DELETE_ME                      USERS

Received on Mon Aug 23 2004 - 03:27:57 CDT