C:/Documents and Settings/gqgai>sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.6.0 - Production on Fri Mar 4 20:55:59 2005Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Connected to:Oracle9i EntERPrise Edition Release 9.2.0.6.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - Production20:55:59 SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.20:56:14 SQL> startupORACLE instance started.Total System Global Area   59842188 bytesFixed Size                   454284 bytesVariable Size              33554432 bytesDatabase Buffers           25165824 bytesRedo Buffers                 667648 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 2 - see DBWR trace fileORA-01110: data file 2: 'D:/ORADATA/EYGLE/UNDOTBS01.DBF'20:59:28 SQL> alter database datafile 'D:/ORADATA/EYGLE/UNDOTBS01.DBF' offline drop;Database altered.Elapsed: 00:00:00.0020:59:34 SQL> alter database open;Database altered.Elapsed: 00:00:02.0420:59:40 SQL> select name from v$datafile;NAME-------------------------------------------------------D:/ORADATA/EYGLE/SYSTEM01.DBFD:/ORADATA/EYGLE/UNDOTBS01.DBFD:/ORADATA/EYGLE/PERFSTAT01.DBFD:/ORADATA/EYGLE/EYGLE.DBF21:00:55 SQL> create undo tablespace undotbs221:01:03   2  datafile 'd:/oradata/eygle/undotbs2.dbf' size 10M;Tablespace created.Elapsed: 00:00:02.0221:06:29 SQL> ALTER SYSTEM SET undo_tablespace='UNDOTBS2' ;System altered.Elapsed: 00:00:00.01