Re: Deleting unused datafiles -- possible?

From: Thiru <tmgn_at_excite.com>
Date: Mon, 30 Aug 1999 16:17:14 -0400
Message-ID: <37CAE6CA.919F3B0@excite.com>

You can :

>alter database datafile ' < file name > ' offline drop;

and delete it from the OS.
But this does not remove the file from the Data Dictionary(v$Datafile or Dba_Data_files would still show the file as being 'INVALID' or 'Needs Recovery' ) until you Recreate the Tablespace which might be painful .

-Thiru

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
Received on Mon Aug 30 1999 - 15:17:14 CDT