Re: Unused datafiles

Fred:

Alas, there's no way to drop selected datafiles from a tablespace. I was regretting this fact the other day when I left out the 'K' in a script to add a datafile, and I wound up with a tiny file added to a huge tablespace. Worse yet, it brought me within 1 of max db_files!

In short, you'll have to export/import.

For what it's worth, you can join dba_data_files and dba_extents via the file_id column to find out which data files are actually being used.

Joseph

In article <01bf32a3$bdbb73e0$3e35a99e_at_gal159a>,   "Frederic DEBRUS" <frederic.debrus_at_ces-cdr.be> wrote:
> 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
>

--
Joseph Thvedt
jthvedt_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 14:43:40 CST