--1、查看实例当前所用 undo 表空间及 undo 相关参数
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 86400
undo_tablespace string UNDOTBS2
--2、新建 undo 表空间
create undo tablespace UNDOTBS3 datafile
'+DATA/hxcx/datafile/undotbs3_01.dbf' size 30G autoextend on next 100m maxsize unlimited,
'+DATA/hxcx/datafile/undotbs3_02.dbf' size 30G autoextend on next 100m maxsize unlimited;
create undo tablespace UNDOTBS3 datafile
'+DATA/hxcx/datafile/undotbs1_03.dbf' size 30G autoextend on next 100m maxsize unlimited,
'+DATA/hxcx/datafile/undotbs1_04.dbf' size