Oracle Foundation 02 Temporary TABLESPACE Temp

--View the use/remaining space of temporary files

Sql> select * from V$temp_space_header;

--View the temporary tablespace to which the Scott user belongs

Sql> Select Username, temporary_tablespace from dba_users

where username= ' SCOTT ';
　　

--See which temporary files are currently available

Sql> Select tablespace_name,file_name,bytes/1024/1024 total_m from Dba_temp_files;

--Re-establish a temporary table space

sql> Create temporary tablespace temp1
Tempfile '/u01/app/oracle/oradata/test10g/temp101.dbf ' size 100M;

--Add a temporary tablespace file

sql> Alter tablespace temp add tempfile '/u01/app/oracle/oradata/test10g/temp02.dbf ' size 100M;

--Set the built-in TEMP1 table space to the default temporary tablespace for the database

sql> ALTER DATABASE default temporary tablespace Temp1;

--drop out of the old temp table space

sql> Drop Tablespace temp including contents and datafiles;

Oracle Foundation 02 Temporary TABLESPACE Temp