oracle重建undo表空间

最新推荐文章于 2022-01-13 17:45:55 发布

weixin_30567471

最新推荐文章于 2022-01-13 17:45:55 发布

阅读量122

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/advocate/p/3434006.html

版权

create undo tablespace UNDOTBS2 datafile 'D:\oracle\product\10.2.0\oradata\ttonline\UNDOTBS02.DBF' size 500m reuse autoextend on next 100m;
alter system set undo_tablespace=UNDOTBS2 scope=both;
drop tablespace UNDOTBS1 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

shutdown immediate;

startup mount;

alter database open;

转载于:https://www.cnblogs.com/advocate/p/3434006.html