undo表空间占用数据文件太大，重建undo

create undo tablespace undotbs2 datafile '/u02/oradata/orcl/undotbs2.dbf' size 1000m autoextend on maxsize 1000M;

alter system set undo_tablespace=undotbs2  scope=both;  

create pfile='/home/oracle/p.undo.ora' from spfile;

drop tablespace undotbs1 including contents and datafiles;



create undo tablespace undotbs1 datafile '/u02/oradata/orcl/undotbs1.dbf' size 1000m autoextend on maxsize 1000M;

alter system set undo_tablespace=undotbs1  scope=both;  

create pfile='/home/oracle/p.undo1.ora' from spfile;

drop tablespace undotbs2 including contents and datafiles;

求IT币::Q，。。。。。。。。。。。。。。。