2.如果要缩小现在的undo tablespace,则: -- 创建一个新的小空间的undo tablespace create undo tablespace undotBS2 datafile '/opt/oradata/sid/undotbs2.dbf' size 100m; -- 设置新的表空间为系统undo_tablespace alter system set undo_tablespace=undotBS2; -- Drop 旧的表空间和数据文件 drop tablespace undotbs1 including contents and datafiles;