Re: Deleting unused datafiles -- possible?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 30 Aug 1999 16:03:04 -0400
Message-ID: <37CAE378.55BEC2EE@Unforgettable.com>

Erik Diehn wrote:

> Hello, all. Does anyone know of a way (or if it's possible) to remove
> unused datafiles in Oracle 8? I could resize them down to some miniscule
> value, but I'd like to make things clean and just get rid of them
> altogether.
>
> Thanks for any help.
>
> Erik Diehn
> erikd_at_nospamm.cometsystems.com - nospamm

As long as there are no objects which have segments in the datafile you should be able to drop it.

Ken Received on Mon Aug 30 1999 - 15:03:04 CDT