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

1. startup mount.
2. connect internal;
3. alter database datafile <filename> offline drop;
4. alter database open;
5. drop tablespace <tablespacename>;

junlei_at_my-deja.com wrote in message <7va5ki$8sg$1_at_nnrp1.deja.com>...
>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.
Received on Thu Oct 28 1999 - 16:42:19 CDT