Re: need to startup database without a datafile

From the mount state, alter database datafile X offline; alter database open;
drop tablespace X;

Should do it.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Yannis Markakis" <yannis_removethis_markakis_at_yahoo.com> wrote in message
news:9rklr4$psv$1_at_usenet.otenet.gr...


> Hello all,

> I got this problem,

> a server on Windows 2000 with service pack is running an 8.1.7 oracle

> database. While trying to create a large materialized view the database

> crashed and wouldn't startup again. I found that the datafile which

consists


> a tablespace in which I was creating the materialized view is corrupted

and


> by now I can mount the database but not open it.

>

> I would rather drop that tablespace and the datafile which appears to be

> corrupted that go back to the whole database restore procedure. Is there a

> way that I can start the database without this one tablespace or datafile?

>

> Excuse me if that has been posted again. Any help would be very

appreciated.


>

> Yannis

>

>