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

From: Kathleen Foley <Kathleen.Foley_at_mail.tju.edu>
Date: Thu, 28 Oct 1999 17:29:08 -0400
Message-ID: <7vaev9$rnc$1@elmo.tju.edu>

Restore the files from system backup and then perform a forward recovery.

Kathy in Philadelphia

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:29:08 CDT