alter tablespace 临时表空间名称 shrink space;
查看临时表空间占用情况：
select
*
from
(
Select
a.tablespace_name,
to_char(a.bytes/1024/1024,
'99,999.999'
) total_bytes,
to_char(b.bytes/1024/1024,
'99,999.999'
) free_bytes,
to_char(a.bytes/1024/1024 - b.bytes/1024/1024,
'99,999.999'
) use_bytes,
to_char((1 - b.bytes/a.bytes)*100,
'99.99'
) ||
'%'
use
from
(
select
tablespace_name,
sum
(bytes) bytes
from
dba_data_files
group
by
tablespace_name) a,
(
select
tablespace_name,
sum
(bytes) bytes
from
dba_free_space
group
by
tablespace_name) b
where
a.tablespace_name = b.tablespace_name
union
all
select
c.tablespace_name,
to_char(c.bytes/1024/1024,
'99,999.999'
) total_bytes,
to_char( (c.bytes-d.bytes_used)/1024/1024,
'99,999.999'
) free_bytes,
to_char(d.bytes_used/1024/1024,
'99,999.999'
) use_bytes,
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
)