Temp TableSpace Drop / Create / Alter Add / Shrink in Oracle Database

DROP

------------

DROP TABLESPACE temp3 INCLUDING CONTENTS AND DATAFILES;

CREATE

------------

CREATE TEMPORARY TABLESPACE TEMP3 TEMPFILE '/u01/oracle/db/apps_st/data/TEMP03.DBF' SIZE 8G;

ALTER

------------

ALTER TABLESPACE TEMP3 ADD TEMPFILE '/u01/oracle/db/apps_st/data/TEMP06.DBF' SIZE 8g;

ALTER TABLESPACE TEMP3 ADD TEMPFILE '/u01/oracle/db/apps_st/data/TEMP04.DBF' SIZE 8G;

ALTER TABLESPACE TEMP3 ADD TEMPFILE '/u01/oracle/db/apps_st/data/TEMP07.DBF' SIZE 8g;

ALTER TABLESPACE TEMP3 ADD TEMPFILE '/u01/oracle/db/apps_st/data/TEMP08.DBF' SIZE 16g;

SHRINK

------------

ALTER TABLESPACE TEMP3 SHRINK TEMPFILE '/u01/oracle/db/apps_st/data/TEMP06.DBF' KEEP 8g;

ALTER TABLESPACE TEMP3 SHRINK TEMPFILE '/u01/oracle/db/apps_st/data/TEMP04.DBF' KEEP 8G;

ALTER TABLESPACE TEMP3 SHRINK TEMPFILE '/u01/oracle/db/apps_st/data/TEMP07.DBF' KEEP 8g;

ALTER TABLESPACE TEMP3 SHRINK TEMPFILE '/u01/oracle/db/apps_st/data/TEMP08.DBF' KEEP 16g;

Source: R&D