1 查看undo的表空间大小和最大值
select t.file_name,t.tablespace_name,
t.bytes/1024/1024/1024 "GB", t.maxbytes/1024/1024/1024 "Max GB"
from dba_data_files t where t.tablespace_name='UNDOTBS1'
--数据文件为:/Oracle/oradata/undo/undotbs01.dbf
2 创建一个新的undo表空间,用来替换原来的undo表空间
create undo tablespace UNDOTBS2
datafile '/Oracle/oradata/log/undotbs02.dbf'
size 10M autoextend on maxsize unlimited;
3 把新的undo表空间设置成数据库的undo表空间
alter system set undo_tablespace=UNDOTBS2 scope=both;