oracle---临时表空间

--临时表空间
select * from dba_tablespaces where contents like 'TEMP%';

select * from v$tempfile f, v$tablespace t where f.TS# = t.TS# ;

create TEMPORARY tablespace jinlian_temp
tempfile 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\JINLIAN.DBF'
size 10M
EXTENT management LOCAL
UNIFORM size 2M;

上一篇:oracle move lob 字段到另外的表空间


下一篇:oracle查询表空间