環境にあわせて読み替えて下さい。

・現在　UNDOTBS1
確認方法は以下
SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;

・一時退避領域作成
create undo tablespace UNDOTBS2 datafile ‘C:\app\Administrator\oradata\サービス名/undotbs02.dbf’ size 10m;
・紐づけ
alter system set undo_tablespace = ‘UNDOTBS2′;

・削除、再作成
drop tablespace UNDOTBS1;
create undo tablespace UNDOTBS1 datafile ‘C:\app\Administrator\oradata\サービス名\undotbs01.dbf’ size 100m reuse autoextend off;
alter system set undo_tablespace = ‘UNDOTBS1′;

・削除
drop tablespace UNDOTBS02 including contents cascade constraints;

・確認
SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;
 

Pocket