that'll teach me to post from memory rather than grabbing the sql reference.
David is of course quite right.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"David Fitzjarrell" <oratune_at_aol.com> wrote in message
news:91aoft$rlo$1_at_nnrp1.deja.com...
> 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/
Received on Fri Dec 15 2000 - 03:03:32 CST
