Re: Dropping a Datafile

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 Received on Tue Oct 21 1997 - 00:00:00 CDT