Re: Removing Datafiles.

Hi,

if you can't drop tablespace (production or very large or no backup or ...)
you can resize the datafile to minimal size.

Torsten

Peter Gadah wrote:
>
> Mark,
>
> Anytime that you add a datafile to a tablespace and then you want to delete
> this datafile... you must drop the tablespace as well.
>
> SQL> drop tablespace <tablespace name> including contents;
>
> Let's say that you have 4 datafiles which make up a single tablespace, by
> deleting just one of these datafiles, it will deem your entire tablespace as
> unusable. Hence, having to drop the tablespace. Hope that helps.
>
> mark trudelle wrote:
>
> > I created a datafile to a TableSpace that I no longer need. Is there a way
> > to remove this datafile from database. I'm operating in the following
> > environment:
> >
> > * Oracle ver 7.3.3
> > * HP UNIX VER 10
> >
> > Please send resonses to: kurt_at_totalnetnh.net
Received on Thu Jan 21 1999 - 01:36:30 CST