Como redefinir el UNDO tablespace

[Wilo]

-- Start of UNDO rezise script
connect / as sysdba

set termout on
spool resize_undo.log

create UNDO tablespace UNDO2
datafile '<file location>/UNDO201.dbf' size 200M
REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 500M;

Alter system set undo_tablespace=UNDO2;

drop tablespace UNDO;

PAUSE "Remove UNDO datafile and hit return"

create UNDO tablespace UNDO
datafile '<file location>/UNDO01.dbf' size 200M
REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 500M;

Alter system set undo_tablespace=UNDO;

Drop tablespace UNDO2;

PAUSE "Remove UNDO2 datafile '<file location>/UNDO201.dbf and hit
return"

spool off
-- End of UNDO resize script