Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I delete a tablespace after I deleted the data file by mistake?
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