1.登录数据库并查看undo表空间大小
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 18:11:48 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select file_name,bytes/1024/1024 MB from dba_data_files;
FILE_NAME MB
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl1/users01.dbf 5
/u01/app/oracle/oradata/orcl1/undotbs01.dbf 50
/u01/app/oracle/oradata/orcl1/sysaux01.dbf 510
/u01/app/oracle/oradata/orcl1/system01.dbf 740
2.更改表空间大小
SQL> alter database datafile '/u01/app/oracle/oradata/orcl1/undotbs01.dbf' resize 250M;
Database altered.
3.查看是否更改成功
SQL> select file_name,bytes/1024/1024 MB from dba_data_files;
FILE_NAME MB
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl1/users01.dbf 5
/u01/app/oracle/oradata/orcl1/undotbs01.dbf 250
/u01/app/oracle/oradata/orcl1/sysaux01.dbf 510
/u01/app/oracle/oradata/orcl1/system01.dbf 740
