Re: Delete a datafile from a tablespace

Is that quite true?

I thought you could do the offline drop thing and then look at rebuilding the controlfile from a script based on the 'alter database backup controlfile to trace' output. Making sure of course that you leave out the offending file.

Not possible unless you can handle the implications of doing this though.

Personally I would think about renaming the file (and possibiliy moving it) to make it fit in with the conventions of the Tablespace is has accedentally been added to. Then it can be sized up for use as appropriate to the requirements in that Tablespace. Then add a new (and correctly named) file for the originally intended Tabelspace. Or am I just being dense!

Regards Kevin

"Arcangelo" <arcangelo-c_at_yahoo.com> wrote in message news:3ef85cd4$0$30821$afc38c87_at_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 Wed Jun 25 2003 - 03:41:14 CDT