Re: Dropping a Datafile

Thanks to all those that replied. In this case it was as simple as just dropping the tablespace because I'm working with temp and the rollback segs of an offline database.

Then a quick create of the new tablespace and datafiles and I was back in action.

Again, thanks to all those who helped. I'm a unix admin and our company has been without a DBA for 6 months now and I get the unlucky (or lucky) responsibility of learning to be a DBA on a failing database.

Scott

In article <344E3781.14A4_at_bose.com>,
Joseph D. Sumalbag <joseph_sumalbag_at_bose.com> wrote:
>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