I have a follow up question along this line...
Howard's procedure for dropping the tablespace has been posted several times
(very kind of you to post it again, by the way). But my question is let's
say that the datafile isn't really corrupt but simply temporarily
unavailable. Is there any way to add the tablespace back in later on?
Would it work to restore to a point in time before the drop and apply the
redo logs to bring the other tablespaces back up to speed?
If that works, is there any way to do this if you're not archiving the redo
logs?
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3bdde29a$0$21197$afc38c87_at_news.optusnet.com.au...
> 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
> >
> >
>
>
Received on Mon Oct 29 2001 - 17:57:27 CST
