From: jeremy.russell@usa.net (Jeremy Russell)
Newsgroups: comp.databases.oracle,comp.databases.oracle.server
Subject: Re: 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace
Message-ID: <3a5120a8.192654462@news.earthlink.net>
References: <918lv0$6ud$1@nnrp1.deja.com>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 22
Date: Tue, 02 Jan 2001 00:33:13 GMT
NNTP-Posting-Host: 63.50.148.149
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread1.prod.itd.earthlink.net 978395593 63.50.148.149 (Mon, 01 Jan 2001 16:33:13 PST)
NNTP-Posting-Date: Mon, 01 Jan 2001 16:33:13 PST
Organization: EarthLink Inc. -- http://www.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@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/