1 SQL>startuo mount

2 SQL>alter system set undo_management=manual scope=spfile;

3 SQL>shutdown

4 SQL>startup mount;

5 SQL> alter database datafile '/home/oracle/oracle/oradata/star/undotbs01.dbf' offline drop;

6 SQL>alter database open;

7 SQL> alter tablespace undotbs1 add datafile '/home/oracle/oracle/oradata/star/undotbs02.dbf' size 500M;

或者

SQL>drop tablespace undotbs1 including contents and datafiles;

SQL>create undo tablespace undotbs1 datafile '/home/oracle/oracle/oradata/ star/undotbs01.dbf’ size 500M;

8 SQL>alter system set undo_management=auto scope=spfile;

9 SQL>shutdown immediate

10 SQL>startup

ITPub博客

重新创建undotbs