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;

--默认临时表空间
select * from database_properties where property_name like 'DEFAULT%';

--更改临时表空间
alter database default TEMPORARY TABLESPACE jinlian_temp;
alter database default TEMPORARY TABLESPACE TEMP;

--设置表空间为脱机
alter tablespace jinlian_temp OFFLINE;

--设置只读
alter tablespace jinlian_temp read only;--WRITE

posted @ 2020-04-01 20:45  八风不动  阅读(155)  评论(0)    收藏  举报