12.2 设置local_temp_tablespace
sql> select username,default_tablespace,temporary_tablespace,local_temp_tablespace from dba_users;
username default_tablespace temporary_tablespace local_temp_tablespace
————————- —————————— —————————— ——————————
sys system tbsb_nytmp temp
system system tbsb_nytmp temp
sibp_ny system tbsb_nytmp temp
select ‘alter user ‘||username||’ local temporary tablespace ‘||temporary_tablespace||’;’
from dba_users where username not in (‘xs$null’);
sql> select username,default_tablespace,temporary_tablespace,local_temp_tablespace from dba_users;
username default_tablespace temporary_tablespace local_temp_tablespace
————————- —————————— —————————— ——————————
xs$null system tbsb_nytmp temp
sys system tbsb_nytmp tbsb_nytmp
system system tbsb_nytmp tbsb_nytmp
gsmcatuser system tbsb_nytmp tbsb_nytmp