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