Re: assigning a tablespace to a user - how?

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

>
> 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 !)

>
> Can this be looked up in the web (docs in the web) somewhere?
> I'm without my Oracle CD and documentation at the moment.

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

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

Hth
Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG