SQL>start up
ORA-01157:cannot identify/lock data file 2 - see DBWR trace file
ORA-011110:data file 2 "'undotbs01.dbf'
SQL> alter database datafile '/u01/app/oracle/oradata/ora11/undotbs01.dbf' offline drop;
SQL>alter database open;
SQL>create undo tablespace undotbs2 datafile '/u01/app/oracle/oradata/ora11/udotbs2.dbf' size 50m;
SQL>alter system set undo_tablespace=undotbs2;
SQL>drop tablespace undotbs1;(不能有活动数据)