1、create undo tablespace undotbs02 datafile '/data/orcl/UNDOTBS02.DBF' size 10m autoextend on maxsize 1000m;
创建新的空间
2、alter system set undo_tablespace=undotbs02 scope=both ;
新旧切换
3、select t.segment_name , t.tablespace_name, t.segment_id, t.status from dba_rollback_segs t;
等待切换完毕,时间可能会长些
4、drop tablespace undotbs1 including contents and datafiles;
删除旧的空间
5、如果df -h发现磁盘没释放 ,需要重启oracle