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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Specifying default tablespace when creating an user?

Re: Specifying default tablespace when creating an user?

From: Martin Pfingstl <mpfingstl_at_lhsystemsas.de>
Date: Tue, 20 Jul 1999 10:48:13 +0200
Message-ID: <7n1d4g$pjt@ar4dec01.ar4.fra.dlh.de>


>> and temp tablespace that he should not have. When I create an user, how
>> do I specify what tablespace he has a default and as temp?

Sybrand Bakker wrote <932421253.20036.0.pluto.d4ee154e_at_news.demon.nl>...
>create user <username>
>identified by <password>
>default tablespace <def tablespace>
>temporary tablespace <temp tablespace>;
>/

and if you want to change the default/temporary tablespace use: alter user <username>
default tablespace <def tablespace>
temporary tablespace <temp tablespace>; /

Best regards,
  Martin Pfingstl Received on Tue Jul 20 1999 - 03:48:13 CDT

Original text of this message

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