Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I delete a tablespace after I deleted the data file by mistake?

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

From: Marti King <martik_at_tmpl.ca>
Date: Thu, 28 Oct 1999 17:24:17 -0700
Message-ID: <3818E931.71AEABE2@tmpl.ca>


You could set trace on, run all possible programs and ad-hoc queries, then analyze the tkprof output to determine which columns are being used.

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.
Received on Thu Oct 28 1999 - 19:24:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US