Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DROP TABLESPACE question
Unknown <zgeist_at_ee.ee.net> wrote in article <5g17kj$4hd_at_news1.ee.net>...
>
> Greetings all -
>
> We have a 7.1.4 machine on which someone deleted dbfs before
> dropping associated tablespace. The tablespace wasn't needed and was
> going to be deleted anyway but, of course, Oracle had a fit when the
> dbfs went away.
>
> Is there a way to allow Oracle to drop the tablespace, even if the
> associated dbfs are not present ?
>
>
> Thanks in advance.
>
> Brett
> zgeist_at_ee.net
>
Hello,
What u can do is:
1. startup mount 2. alter database datafile 'lost file' offline; 3. alter database mount 4. drop tablespace Tbs icluding contents
should work Received on Thu Mar 13 1997 - 00:00:00 CST