Temporary tablespace and files management in oracle

CREATE TEMP TABLESPACE:
-----------------------
CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '/u01/oradata/tst/temp01.dbf' size 1024M extent management local uniform size 1M;
CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '+ORA_DB' SIZE 1G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;


ADD TEMP FILES IN TEMPORARY TABLESPACE:
---------------------------------------
ALTER TABLESPACE TEMP01 ADD tempfile '/u01/oradata/tst/temp02.dbf' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE 20G;
ALTER TABLESPACE TEMP01 ADD tempfile '+ORA_DB' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;


DROP TEMP TABLESPACE:
---------------------
DROP TABLESPACE TEMP01 including contents and datafiles;


LIST ALL TEMPFILES OF TEMP TABLESPACE:
-------------------------------------

SQL> col file_name for a45
select tablespace_name,file_name,bytes/1024/1024,maxbytes/1024/1024,autoextensible from dba_temp_files order by file_name;

TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024 AUTOEXTENSIBLE
---------------- ---------------------------------- --------------- ------------------ ------------------
TEMP01 /u01/oradata/tst/temp01.dbf 300 0 NO
TEMP01 /u01/oradata/tst/temp02.dbf 20 32767 YES



SET DEFAULT TEMP TABLESPACE:
---------------------------
alter database default temporary tablespace TEMP;

SET DEFAULT TEMP TABLESPACE FOR USER:
-------------------------------------
ALTER USER SYSADM TEMPORARY TABLESPACE PSTEMP1;
ALTER USER PEOPLE TEMPORARY TABLESPACE PSTEMP1;