Re: How to drop Datafile from Tablespace?

Your best option at this point is to try resizing the datafiles as small as possible, so that nothing else will ever use them. But, you can't get rid of them entirely without recreating the tablespace

Rick wrote:

> John Koo wrote:
> >
> > Adrian Harrison wrote:
> >
> > > Had to add several datafiles to an existing Tablespace for testing reasons!
> > >
> > > Can't find how to remove them! - I don't want to have to drop the tablespace itself!
> > >
> > > Any ideas
> > >
> > > Thanks
> > >
> > > A.H
> >
> > Just want to let you know there is NO WAY to drop an added datafile from a tablespace.
> > If you don't believe then go to check the ALTER TABLESPACE syntax.
> > What you ARE SUPPOSED to do is to create a temporary-used tablespace for testing
> > and then dropped it completely after use. Get it ?
> >
> > John Koo
> > johnkoo_at_i-wave.net
> John is absolutely right on this. You have no way of knowing whether
> any table data is stored in the datafile you want to drop. So it makes
> no sense to try.
>
> Rick

Received on Wed Jan 20 1999 - 11:13:08 CST