前端之家收集整理的这篇文章主要介绍了
Oracle表空间-临时表空间新建、更改，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
1、新建
sql> create
temporary tablespace lianxi_temp
2 tempfile 'C:\orcl1122\disk5\lianxi_temp.dbf'
3 size 10M
4 extent management local
5 uniform size 2M;
Tablespace created
sql>
2、
查询
sql> select * from dba_tablespaces where tablespace_name like '%LIAN%';
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE PREDICATE_EVALUATION ENCRYPTED COMPRESS_FOR
------------------------------ ---------- -------------- ----------- ----------- ----------- ---------- ------------ ---------- --------- --------- --------- ------------- ----------------- --------------- ---------- ------------------------ ------------------- ----------- ------- -------------------- --------- ------------
LIANXI 8192 57344 57344 1 2147483645 2147483645 0 57344 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED NOT APPLY NO HOST NO
LIANXI_UNDO 8192 65536 1 2147483645 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
LIANXI_TEMP 8192 2097152 2097152 1 2147483645 0 2097152 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
更改默认临时表空间
sql> alter database
default temporary tablespace lianxi_temp; Database altered
查询是否更改
sql> select * from database_properties where property_name like'DEFA%'; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- DEFAULT_TEMP_TABLESPACE LIANXI_TEMP
原文链接：https://www.f2er.com/oracle/207630.html
