ORACLE临时表空间满 temporary

--查询默认临时表空间：
select * from database_properties where property_name='DEFAULT_TEMP_TABLESPACE';

--查询临时表空间状态:
select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files;

 

--查看一下谁在用临时段
SELECT se.username,
sid,
serial#,
sql_address,
machine,
program,
tablespace,
segtype,
contents
FROM v$session se,
v$sort_usage su
WHERE se.saddr=su.session_addr;

SQL> Alter system kill session 'sid,serial#';

 

 

create temporary tablespace temp02 tempfile 'D:\seineebs\seineebs\temp02.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED;
alter database default temporary tablespace temp02;
drop tablespace temp01 including contents and datafiles;