oracle 上 迁移 undo 表空间的步骤

oracle 上 迁移 undo 表空间的步骤:

  1 .重建undo 表空间
          SQL> create UNDO tablespace undotbs2
               2  datafile 'E:\ora_data\UNDOTBS02.DBF' size 2048m
               3  autoextend on next 1m maxsize 20480m;
                  Tablespace   created
  2 .修改系统设置
      SQL> alter system set undo_tablespace= undotbs2;