Re: How to drop a datafile?

From: Chan Wai Sum <chan_at_realTech.de>
Date: Thu, 22 Apr 1999 17:14:10 +0800
Message-ID: <371EE862.69E0C146@realTech.de>

Errr, I am afraid not easily. Would require a reorganization of the tablespace I believe.

Wai Sum

Cheong wrote:

> Forgot to say, I do not want to drop the tablespace. I only want to drop the
> newly added datafile. It is possible?
>
> Cheong wrote in message <371e8982_at_news.lhsgroup.com>...
> >Hi:
> >
> >I have added a datafile to abc non-system tablespace, and decided that I
> >should drop the datafile. I am in startup restrict mode, so I know for sure
> >that the newly added datafile is "clean".
> >
> >Can I:
> >
> >ALTER DATABASE my_db
> >DATAFILE 'abc' OFFLINE DROP?
> >
> >TIA
> >Cheong
> >
> >
Received on Thu Apr 22 1999 - 04:14:10 CDT