UNDO の縮小

もうめんどくさいので、コマンドだけ。

 

create undo tablespace UNDOTBS2 datafile '/u01/app/oracle/oradata/TARGET1/undotbs2.dbf' size 10m;
alter system set undo_tablespace=UNDOTBS2 scope=both;
drop tablespace UNDOTBS1 including contents and datafiles;
create undo tablespace UNDOTBS1 datafile '/u01/app/oracle/oradata/TARGET1/undotbs1.dbf' size 100m reuse;
alter system set undo_tablespace = 'UNDOTBS1';
drop tablespace UNDOTBS2 including contents and datafiles;