Re: How to drop a datafile?

From: XU <xux_at_informa.bio.caltech.edu>
Date: 23 Apr 1999 00:22:09 GMT
Message-ID: <7foefh$7id@gap.cco.caltech.edu>

It seems that dropping a datafile is impossible. The "offline drop" option of "alter database" does not really drop the datafile. If you query the v$datafile view, the dropped datafile is still there.

Robert Xu

Chan Wai Sum (chan_at_realTech.de) wrote:
: 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 - 19:22:09 CDT