表空间删除

1.如果数据文件已经被删除，

shutdown abort;
startup mount;
alter database datafile '/data/xxt.dbf' offline;
alter database open;
drop tablespace xxt including contents and datafiles;