查看当前库中有多少表空间
select * from dba_temp_files t where t.TABLESPACE_NAME=‘USER_TEMP’
找到相应的DBF文件扩展,默认每次增加50M无限大
alter database tempfile ‘C:\APP\USER\ORADATA\ORCL\TS_USER_TEMP.DBF’ autoextend on next 50M maxsize unlimited;
commit;
(查看内存占用:
select c.tablespace_name,
to_char(c.bytes/1024/1024/1024,‘99,999.999’) total_gb,
to_char( (c.bytes-d.bytes_used)/1024/1024/1024,‘99,999.999’) free_gb,
to_char(d.bytes_used/1024/1024/1024,‘99,999.999’) use_gb,
to_char(d.bytes_used*100/c.bytes,‘99.99’) || '%'use
from (select tablespace_name,sum(bytes) bytes
from dba_temp_files GROUP by tablespace_name) c,
(select tablespace_name,sum(bytes_cached) bytes_used
from v$temp_extent_pool GROUP by tablespace_name) d
where c.tablespace_name = d.tablespace_name;)