- /*系统UNDO表空间的重建*/
- --1. 创建新的UNDO表空间
- CREATE UNDO TABLESPACE "UNDOTEMP"
- DATAFILE '/opt/oracle/product/9.2.0.4/dbs/undo01.ora' SIZE 5 m
-
- --2. 在OEM控制台修改系统默认的UNDO表空间名, 由UNDOTBS改为UNDOTEMP, 或通过下面的命令修改默认UNDO表空间的标识
- ALTER SYSTEM SET undo_tablespace = undotemp
- --3. 删除原来的系统默认UNDO表空间, 并重建UNDOTBS
- DROP TABLESPACE "UNDO02" INCLUDING CONTENTS AND DATAFILES
- CREATE UNDO TABLESPACE "UNDOTBS"
- DATAFILE '/opt/oracle/product/9.2.0.4/dbs/undo01.dbf' SIZE 200 m
- AUTOEXTEND ON NEXT 4096 k --MAXSIZE 500M
- --4. 在OEM控制台修改系统默认的UNDO表空间名, 由 UNDOTEMP 改为 UNDOTBS, 改回原有的UNDO表空间标识
- ALTER SYSTEM SET undo_tablespace = undotbs
- --5. 删除临时创建的UNDO表空间UNDOTEMP
- DROP TABLESPACE "UNDOTEMP" INCLUDING CONTENTS AND DATAFILES