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