Re: Dropping a Datafile

From: Matt Southcott <matts_at_xxxnifcosynergy.com>
Date: 1997/10/22
Message-ID: <344e2c3e.58237511@news.bctel.net>#1/1

I did that but I forgot that if it is associated to an active tablespace but is not being used then I can't drop it. Any idea what I should do for that??? The datafile is empty and has been offline for 4 months so as you can imagine I have not kept 4 months worth of redo logs. The tabelspace is in use but not this particular datafile.

On Tue, 21 Oct 1997 17:10:41 -0400, Amit Aggarwal <amaggarwal_at_kendle.com> 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
Received on Wed Oct 22 1997 - 00:00:00 CDT