Dropping a tempfile only without dropping the temp tablespace

The datafiles from a tablespace can not be removed until you drop the entire tablespace. However, one can remove a TEMPFILE from a database without dropping the tablespac

SQL> select tablespace_name,file_id,bytes_used,bytes_free from v$temp_space_header;

TABLESPACE_NAME                  FILE_ID BYTES_USED BYTES_FREE
------------------------------ --------- ---------- ----------

TEMP                                        1          2.147E+09                     0

CELLTEMP                                  2          1048576           1.048E+09

Now let us add a tempfile to TEMP tablespace

SQL>alter tablespace temp add tempfile '/temp/temp01.dbf' size 2048M;
Tablespace altered.

 

SQL> alter database tempfile '/temp/temp.dbf' drop including datafiles;
Database altered.