Re: Deleting unused datafiles -- possible?
From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: 1999/08/30
Message-ID: <37CAE378.55BEC2EE_at_Unforgettable.com>#1/1
Date: 1999/08/30
Message-ID: <37CAE378.55BEC2EE_at_Unforgettable.com>#1/1
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 - 00:00:00 CEST