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: DROP TABLESPACE question

Re: DROP TABLESPACE question

From: Muli Koppel <koppel_at_post.tau.ac.il>
Date: 1997/03/13
Message-ID: <01bc2fd7$c3a6e4a0$2d214284@133.66.32.10.tau.ac.il>#1/1

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

Original text of this message

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