Oracle回滚段过大后的解决

首先确保无当前回滚段无活动，然后建新的表空间，切换，删除旧的。
CREATE UNDO
TABLESPACE UNDOTBS02
DATAFILE ‘/data3/oracle/oradata/ourde/undotbs02.dbf’ SIZE 1000M REUSE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

alter system set UNDO_TABLESPACE=UNDOTBS02

drop tablespace UNDOTBS1 including contents and datafiles;