Note:
You cannot take a temporary tablespace online. Instead, you take its tempfile online.
The following statement take tempfile online.
SQL> ALTER DATABASE TEMPFILE '<path_and_file_name>' ONLINE;
Example:
SQL> ALTER DATABASE TEMPFILE '/u01/oradata/ORCL10G/temp01.dbf' ONLINE;
Database altered.
SQL>
To display the status for a tempfile.
col name for a35
select NAME, STATUS from V$TEMPFILE;
SQL> col name for a35
select NAME, STATUS from V$TEMPFILE;SQL>
NAME STATUS
----------------------------------- -------
/u01/oradata/ORCL10G/temp01.dbf ONLINE
SQL>