create temporary tablespace loadtest_temp tempfile size 1G autoextend on next 1M;
alter user loadtest temporary tablespace loadtest_temp;
alter user 用户名 default/temporary tablespace 表空间名;
select tablespace_name, file_name from dba_temp_files;
select username, temporary_tablespace from dba_users where temporary_tablespace='LOADTEST_TEMP';