need to startup database without a datafile

From: Yannis Markakis <yannis_removethis_markakis_at_yahoo.com>
Date: Tue, 30 Oct 2001 00:39:31 +0200
Message-ID: <9rklr4$psv$1@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 Received on Mon Oct 29 2001 - 16:39:31 CST