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

Home -> Community -> Usenet -> c.d.o.server -> Re: 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

From: Jeremy Russell <jeremy.russell_at_usa.net>
Date: Tue, 02 Jan 2001 00:33:13 GMT
Message-ID: <3a5120a8.192654462@news.earthlink.net>

Use 'STARTUP MOUNT', then take the tablespaces with missing DBF's offline. After that, you ought to be able to 'ALTER DATABASE OPEN' and then drop the tablespaces completely.

Jeremy Russell

On Wed, 13 Dec 2000 20:25:14 GMT, eric_dewerth_at_my-deja.com wrote:

>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/
Received on Mon Jan 01 2001 - 18:33:13 CST