Re: Deleting unused datafiles -- possible?

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 - 00:00:00 CEST