undo表空间

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_tables来4源gaodaimacom搞#代%码*网pace=’UNDOTBS1′;
drop tablespace UNDOTBS including contents and datafiles;
shutdown immediate;
startup

喜欢 (0)赏

[搞代码]

分享 (0)