oracle 失誤刪掉資料檔案後，刪除表空間操作

失誤刪掉資料檔案後，刪除表空間操作。
SQL> drop tablespace sms;
drop tablespace sms
*
ERROR at line 1:
ORA-01116: error in opening database file 15
ORA-01110: data file 15: '/u01/app/oracle/oradata/orcl/sms.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/sms.dbf' offline drop;
Database altered.

SQL> drop tablespace sms;
Tablespace dropped.

[@more@]