Oracle切换Undo表空间

参考文档：How to Switch to a New Undo Tablespace (Doc ID 1951695.1)

1. 查看当前默认undo表空间

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2

2. 创建新的Undo表空间，根据需求制定数据文件大小

SQL> create undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/orcl/undotbs1_01.dbf' size 100m autoextend off;

Tablespace created.

3. 切换到新的Undo表空间

SQL> alter system s