开发环境的UNDO竟然涨到10G,天啊!好在是开发环境,直接重建:
1. ORACLE
CREATE UNTO TABLESPACE UNDO_NEW DATAFILE '/ORACLE/ORADATA/ORCL/UNDO01.DBF' SIZE 500M;
ALTER SYSTEM SET UNDO_TABLESPACE='UNDO_NEW';
DROP TABLESPACE UNDOTBS1;
2.手工删除数据文件
开发环境的UNDO竟然涨到10G,天啊!好在是开发环境,直接重建:
1. ORACLE
CREATE UNTO TABLESPACE UNDO_NEW DATAFILE '/ORACLE/ORADATA/ORCL/UNDO01.DBF' SIZE 500M;
ALTER SYSTEM SET UNDO_TABLESPACE='UNDO_NEW';
DROP TABLESPACE UNDOTBS1;
2.手工删除数据文件