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