Re: DROP TABLESPACE question

From: Naren Chintala <naren_at_mink.att.com>
Date: 1997/03/11
Message-ID: <332570B1.2081@mink.att.com>#1/1

Unknown wrote:
>
> 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

SQLDBA> alter database datafile 'filename' offline drop; SQLDBA> drop tablespace 'tablespace_name'; -- This command can only be executed if the database is open.

-- 
Naren Chintala

Received on Tue Mar 11 1997 - 00:00:00 CST