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
上一篇: ASP.NET对HTML页面元素进行权限控制(一)
下一篇: 用于测试api接口数据的输入输出