oracle相关,  个人笔记,  性能测试相关

磁盘空间不足,释放回滚段空间

磁盘空间不足,释放回滚段空间
create undo tablespace undotbs2 datafile '/oracle/app/oracle/oradata/EP1/UNDOTBS02.DBF' size 20m; 
alter system set undo_tablespace=undotbs2 scope=both;
drop tablespace undotbs1 including contents; 

alter database datafile '/oracle/app/oracle/oradata/EP1/UNDOTBS02.DBF' resize 2048m;

rm -rf /oracle/app/oracle/oradata/EP1/UNDOTBS01.DBF  //删除原回滚段文件

留言

您的邮箱地址不会被公开。 必填项已用 * 标注