Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to drop Datafile from Tablespace?
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 - 16:19:05 CST