Re: assigning a tablespace to a user - how?

Thomas Schwickert <schwickert_at_yahoo.com> wrote:
: Hi

: "Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message
: news:9orvc6$ejh$2_at_nets3.rz.RWTH-Aachen.DE...

:> When I create a user and this user creates tables this seems to go :> by default into the sys tablespace.

: SYS ? Should be SYSTEM I'd think

Yes, correct. I was thinking of the files SYS$something.

:>
:> By which statement can I assign a certain tablespace to a user?

: ALTER USER user_to_change DEFAULT TABLESPACE tspace_name TEMPORARY TABLESPACE
: temp_ts

: (temporary should also set !)

Thanks.

: Documentation (searchable) for 8i (8.1.7) and 9i (9.0.1)
: http://tahiti.oracle.com/

: Hth
: Thomas

-- 
Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de