Re: Unused datafiles

For what is being used and what not, link dba_extents to dba_data_files, or dba_free_space to dba_data_files, link them by tablespace_name and/or file_id, and you will know the answer.
You should be able to do an alter database datafile 'xyz' drop, if the file is completely empty. Otherwise... Yes!

Hth

--
Sybrand Bakker, Oracle DBA
Frederic DEBRUS <frederic.debrus_at_ces-cdr.be> wrote in message news:01bf32a3$bdbb73e0$3e35a99e_at_gal159a...
> Hello there,
>
> I have a tablespace A composed of 6 datafiles A1 to A6
> but I only use 5% of this tablespace is used so I would like to drop some
> datafiles
>
> Is there a way other then export, drop tablespace, recreate, and import to
> do it ?
> also how to report which datafiles is used and which is not....
>
> Some guideline will be appreciated
>
> Many thanks,
> FreD
Received on Fri Nov 19 1999 - 13:11:48 CST