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...


> 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/