Re: Delete a datafile from a tablespace

From: Arcangelo <arcangelo-c_at_yahoo.com>
Date: Wed, 25 Jun 2003 00:14:38 +1000
Message-ID: <3ef85cd4$0$30821$afc38c87@news.optusnet.com.au>

You can *never* drop a datafile from a tablespace once it's been added. Ever. And offline drop doesn't do it either.

The only options are to shrink the file to a stupidly small size that is of no consequence, or to drop the tablespace and re-create it.

;-(

"michael ngong" <mngong_at_yahoo.com> wrote in message news:ecf365d5.0306240330.26f7a49a_at_posting.google.com...
> Hanne Iren Midttun <hannem_at_tihlde.org> wrote in message
news:<Pine.LNX.4.21.0306240857470.31693-100000_at_colargol.tihlde.org>...
> > Hi,
> > I have by accident added a datafile to the wrong tablespace. Can
> > somebody tip me on how can I delete it again?
> >
> > (Never - ever start working before 1 cup of coffee :-)
> >
> > Hanne
>
> An offline drop of the datafile should do it.
> alter datafile '/u01/oradata/myfile' offline drop
> It will be nice to take the necessary precautions though.
> Export all tables in the tablespace,backup, full export ....
> HTH
> Michael Tubuo Ngong
Received on Tue Jun 24 2003 - 09:14:38 CDT