首页 > 其他 > 详细

undo表空间

时间:2014-10-22 10:09:23      阅读:382      评论:0      收藏:0      [点我收藏+]
UNDO表空间数据文件切换
 1 新建一UNDO表空间
 CREATE UNDO TABLESPACE UNDOTBS DATAFILE ‘/dev/vx/rdsk/vgora/lv_undo‘ SIZE 10M AUTOEXTEND ON RETENTION NOGUARANTEE;
 2 切换表空间
 alter system set undo_tablespace=‘UNDOTBS1‘;
 shutdown immediate;
 startup
 drop tablespace UNDOTBS2 including contents and datafiles;
 CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ‘/dev/vx/rdsk/vgora/lv_undo‘ size 6000M;
 alter tablespace UNDOTBS1 add datafile ‘/dev/vx/rdsk/vgora/lv_undo1‘ size 8000M;
 alter system set undo_tablespace=‘UNDOTBS1‘;
 drop tablespace UNDOTBS including contents and datafiles;
 shutdown immediate;
 startup

undo表空间

原文:http://blog.csdn.net/jenya007/article/details/40370731

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!