***********************************************声明***********************************************************************
原创作品,出自 “深蓝的blog” 博客,欢迎转载,转载时请务必注明出处,否则追究版权法律责任。
深蓝的blog:http://blog.csdn.net/huangyanlong/article/details/39935157
****************************************************************************************************************************
实验项目:将undo表空间扩大,然后缩小
SQL> select name,bytes/1024/1024 M from v$datafile;
--查询undo表空间,当前为230m
NAME M
-------------------------------------------------- ----------
/u01/app/oracle/oradata/xcky/system01.dbf 760
/u01/app/oracle/oradata/xcky/sysaux01.dbf 550
/u01/app/oracle/oradata/xcky/undotbs01.dbf 230
/u01/app/oracle/oradata/xcky/users01.dbf 1518.75
/u01/app/oracle/oradata/xcky/example01.dbf 330
(1)、扩展undo表空间
思路:创建一个更大的undo表空间,让后将原undo空间替换
SQL> create undo tablespace undotbs02 datafile '/u01/app/oracle/oradata/xcky/undotbs02.dbf' size 500m reuse autoextend on;
Tablespace created.
SQL> alter system set undo_tablespace=undotbs02;
System altered.
SQL> select name,bytes/1024/1024 M from v$datafile;
--查询会发现,新扩展的undo表空间