Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace
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...Received on Thu Dec 14 2000 - 05:44:25 CST
> 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/