Re: Dropping a Datafile

From: Joseph D. Sumalbag <joseph_sumalbag_at_bose.com>
Date: 1997/10/22
Message-ID: <344E3781.14A4@bose.com>#1/1

Amit Aggarwal wrote:
>
> Matt Southcott wrote:
> >
> > I just cannot find this info in any of my books here I guess this is
> > not a usual thing to do. I have done this before but for the life of
> > me I can't remember how. I want to drop a datafile that is no longer
> > of any use due to political bickering between 2 companies. Please
> > tell me how. You can call me names later.
>
> alter database datafile <datafile> offline drop;
>
> amit
> Oracle DBA/Unix SA

Maybe you have to drop the tablespace too , Some of the segment may have grown beyond the remaining datafiles and used the dropped datafile of the tablespace . in that case you may have problems . Received on Wed Oct 22 1997 - 00:00:00 CDT