Re: Removing Datafiles.

From: Peter Gadah <pgadah_at_magicnet.net>
Date: 21 Jan 1999 05:10:59 GMT
Message-ID: <36A6B6F5.4B5B73C1@magicnet.net>

Mark,

Anytime that you add a datafile to a tablespace and then you want to delete this datafile... you must drop the tablespace as well.

SQL> drop tablespace <tablespace name> including contents;

Let's say that you have 4 datafiles which make up a single tablespace, by deleting just one of these datafiles, it will deem your entire tablespace as unusable. Hence, having to drop the tablespace. Hope that helps.

mark trudelle wrote:

> I created a datafile to a TableSpace that I no longer need. Is there a way
> to remove this datafile from database. I'm operating in the following
> environment:
>
> * Oracle ver 7.3.3
> * HP UNIX VER 10
>
> Please send resonses to: kurt_at_totalnetnh.net
Received on Wed Jan 20 1999 - 23:10:59 CST