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

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:208

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;

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】