欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

undo表空间

程序员文章站 2024-01-18 19:41:46
...

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; start

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