Oracle Temp Table Space

Environment:

OS:

Oracle Linux Server Release 5.7

Db:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

1. View Temporal tablespace Information:

Select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from Dba_temp_files;

tablespace file_name file_size Autoexten
---------- ---------------------------------------- ---------- ---------
TEMP/U01/ORACLE/ORADATA/YOON/TEMP01.DBF YES

2, add data file, Tempfile,not datafile

sql> Alter tablespace temp add tempfile '/u01/oracle/oradata/yoon/temp02.dbf ' size 100m;

3. Create a temporary table space

sql> Create temporary tablespace temp2 tempfile '/u01/oracle/oradata/yoon/temp2_01.dbf ' size 100m autoextend on next 50 M

4. Delete temporary table space

Sql> drop tablespace temp2 including contents and datafiles;

5. Modify the default temp table space

sql> ALTER DATABASE default temporary tablespace temp2;

6. Modify the User default temp table space

sql> alter user Scott temporary tablespace temp;

Oracle Temp Table Space