It was mounted but say it can not complete this because the INSTANCE is
not OPEN. Any other suggestions or should I just drop the dB and
recreate it. Its really not that important, just wanted to know for
personal reference in case I ever run into that.
> > From memory so check the syntax.
> > alter tablespace X offline drop;
> > regards
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > > I have an 8i dB with several Tablespaces the were deleted by rm
> > > the .dbf instead of removing the tablespace. It is causing the
> > > Instance not to OPEN...It will MOUNT but not OPEN. How do I get
> > > to recognize that the tablespace is gone? How do I remove the
> > > tablespace since there is no .dbf associated with it?
> > > Thanks,
> > > Eric
> > > Sent via Deja.com
> > > http://www.deja.com/
> Mount the database, then issue the following:
> drop tablespace ... including contents;
> This should drop the "offending" tablespace and allow the instance to
> ALTER TABLESPACE can take a tablespace offline but there is no DROP
> option. One can take a datafile offline and drop it with ALTER
> DATABASE DATAFILE ... OFFLINE DROP.
> David Fitzjarrell
> Oracle Certified DBA
> Sent via Deja.com
Sent via Deja.com