-
hi
I am using Oracle9i.
I created one more UNDO tablespace for testing purpose.
After that i dropped this tablespace datafile (undo tablespace)
using alter database...offline drop command.
Deleted the file using OS command.
When i restarted the DB as SYS user i could not able to start it.The instance is referring the Datafile which i dropped.
How to remove this reference or kindly help me if anyone knows about this problem.
I am sending the trace file error.
Thanks in advance,
S.Kumar
The trace file messages,
Dump file F:\oracle\admin\citimis1\udump\ORA00948.TRC
Mon Mar 12 22:27:06 2001
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Windows 2000 Version 5.0 , CPU type 586
Instance name: citimis1
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 948, image: ORACLE.EXE
*** SESSION ID:(7.1) 2001-03-12 22:27:06.000
Evaluating checkpoint for thread 1 sequence 242 block 3
*** 2001-03-12 22:27:07.000
KCRA: start recovery buffer claims
*** 2001-03-12 22:27:07.000
KCRA: buffers claimed = 7/7, eliminated = 0
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'F:\ORACLE\ORADATA\CITIMIS1\UNDOTBS01.DBF'
-
Dropping the datafile is not the same as dropping the tablespace. You will have to startup mount and then drop the undo tablespace.
