Oracle UNDO領域を変更する
sqlplus / as sysdba
set pages 10000
set lines 120
col NAME for a40
col bytes for 999,999,999,999
select file#, bytes, name from v$datafile where upper(name) like '%UNDO%';
ALTER DATABASE DATAFILE '/xxx/yyy/UNDO.DBF' RESIZE 3G;
sqlplus / as sysdba
set pages 10000
set lines 120
col NAME for a40
col bytes for 999,999,999,999
select file#, bytes, name from v$datafile where upper(name) like '%UNDO%';
ALTER DATABASE DATAFILE '/xxx/yyy/UNDO.DBF' RESIZE 3G;