Re: How do I delete a tablespace after I deleted the data file by mistake?

It's been awhile, but I believe that you can clear this up by going into svrmgr:
1. STARTUP MOUNT
2. ALTER DATABASE DATAFILE 'filename' OFFLINE DROP ;

        — This will remove the missing datafile from the database. 3. ALTER TABLESPACE tablespace_name OFFLINE ;

        — This should take the tablespace offline. 4. ALTER DATABASE OPEN ;
5. DROP TABLESPACE tablespace_name ;

HTH
    James
In article <7va5ki$8sg$1_at_nnrp1.deja.com>,   junlei_at_my-deja.com wrote:
> In the process of creating a bunch of tablespaces, I made a mistake
> with the initial extent size for some tablespaces. I decided to
> delete them.
> Then I proceeded to delelte the corresponding datafiles. That's when
> I mistakenly deleted 2 datafiles corresponding to two tablespaces not
> yet deleted. Now, I can't do anything to these two tablespaces,
> not even to take them offline. So I have set the quoto to none on
> these tablespaces for the time being.
>
> Does anyone know how I can solve this problem?
>
> Thanks.
>
> Junlei
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 14:36:35 CDT