select username,default_tablespace,temporary_tablespace from user_users;用alter user 改变用户的默认表空间和临时表空间.举例:alter user system default tablespace usertemporary tablespace temp;