에러 메시지
ORA-01110: data file 201: '/opt/oracle/oradata/temp01.dbf'
ORA-27041: unable to open file

1) Recovery 시작
SQL> drop tablespace temp including contents and datafiles;
drop tablespace temp including contents and datafiles
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace


SQL> create temporary tablespace temp2
  2  tempfile '$HOME/oradata/HUMAN/temp2.dbf' size 50m;

Tablespace created.

SQL>  alter database default temporary tablespace temp2;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

SQL> select username,temporary_tablespace from dba_users;

USERNAME                      TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYS                            TEMP2
SYSTEM                        TEMP2
OUTLN                          TEMP2
DBSNMP                        TEMP2
NANUNE                        NANUNETEMP
HR                            TEMP2
WKPROXY                        TEMP2

2) 정상인가 확인
SQL>select a.last_name from hr.emphist a,hr.emphist,hr.emphist order by 1;