UNDO表空间过大，切换UNDO,删除原表空间

C:\\Documents and Settings\\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 12 16:48:41 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create undo tablespace undotbs2 datafile 'd:\\UNDOTBS02.dbf' size 1000m reuse autoextend on next 800m maxsize unlimited;

表空间已创建。

SQL> create undo tablespace undotbs3 datafile 'e:\\UNDOTBS03.dbf' size 1000m reus
e autoextend on next 800m maxsize unlimited;

表空间已创建。

SQL> alter system set undo_tablespace=undotbs3 scope=both;

系统已更改。

SQL> drop tablespace undotbs2 including contents and datafiles;

表空间已删除。

SQL> drop tablespace undotbs1 including contents and datafiles;

表空间已删除。


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------

D:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\SYSTEM01.DBF
D:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\SYSAUX01.DBF
D:\\ORACLE\\PRODUCT\\10.2.0\\REPORTVI\\USERS01.DBF
D:\\USER02.DBF
E:\\USER03.DBF
E:\\USER04.DBF
E:\\USER05.DBF
E:\\USER06.DBF
E:\\UNDOTBS03.DBF

已选择9行。