create undo tablespace undotbs1 datafile ‘/home/oracle/product/11.2.0/oradata/srcl/undotbs01.dbf‘ size 10240m reuse;
alter system set undo_tablespace=undotbs1 scope=both;
alter tablespace UNDOTBS4 offline;
drop tablespace UNDOTBS4 including contents and datafiles cascade constraints;
58数据库重建表空间记录
原文:http://www.cnblogs.com/caogang/p/4553975.html