Re: 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

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.

Eric

In article <91aoft$rlo$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> In our last gripping episode "Niall Litchfield" <n-litchfield_at_audit-
> commission.gov.uk> wrote:
> > From memory so check the syntax.
> >
> > alter tablespace X offline drop;
> >
> > regards
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > <eric_dewerth_at_my-deja.com> wrote in message
> > news:918lv0$6ud$1_at_nnrp1.deja.com...
> > > 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
 Oracle
> > > 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
> open.
>
> 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
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Sat Dec 16 2000 - 05:16:44 CET