Re: Corrupt Tablespace Datafile

You should try
with the database in mount mode

alter database drop datafile
or
alter database datafile offline
which will then allow you to open the database and then drop the tablespace

 .

JHY wrote in message <6orj4l$okk_at_bgtnsc02.worldnet.att.net>...
>Try mounting the database without opening it. You should be able to drop
the
>tablespace then open the database.
>
>bmennell_at_bftl.com wrote:
>
>> I created a new tablespace using the Storage Manager. There was no error
>> reported but it failed to create a proper data file due to there being
>> insufficient space on disk. In fact it created a zero-length data file.
>>
>> After the next server shutdown, the database would not open, and gave
these
>> error messages:
>>
>> ORA-01157: cannot identify data file 8 - file not found
>> ORA-01110: data file 8: 'D:\ORANT\DATABASE\OEM1ORCL.ORA'
>> ORA-27048: skgfifi: file header information is invalid
>> OSD-04004: invalid file header
>>
>> We have tried to use svrmgr to take the tablespce off-line using
>> 'alter tablespace <name> offline'
>> but we get the message 'ORA-1109 database not open'.
>>
>> So we have a catch-22 situation: the database will not open because a
>> tablespace datafile it expects is not there, and we cannot disable the
>> tablespace unless the database is open.
>>
>> There must surely be a way of altering the Oracle configuration settings
>> (without the database being open) in such a way as to disable a bad
>> tablespace data file.
>>
>> Any ideas ?
>>
>> We are using Oracle 8.0.3 on Windows NT.
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>
>
Received on Mon Jul 20 1998 - 18:45:10 CDT