如何得到某个用户的默认表空间和临时表空间？？？？

[hachenzhonghua]

每个用户创建的时候都有默认表空间和临时表空间，建表只要不指定表空间名都会将表建立在该表空间中，我如何通过代码指导当前用户的默认表空间和临时表空间呢？

[black_snail]

select * from user_users
check it

[black_snail]

the default tablespace and temp tablespace for the specific user are assigned during the user creation .

you can use alter user command to change it .

[hachenzhonghua]

明白了，给分！！！
请给出Alter User Command，提前谢过

[w_tsinghua]

select username,default_tablespace,temporary_tablespace from user_users;
用alter user 改变用户的默认表空间和临时表空间

[hrb_qiuyb]

SELECT default_tablespace ,temporary_tablespace FROM user_users

[hachenzhonghua]

改变用户的默认表空间和临时表空间的 Alter user 语法？？？

[hrb_qiuyb]

举例:
alter user system
default tablespace user
temporary tablespace temp;

[beckhambobo]

创建用户不是以指定default空间与temporary空间.