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

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