Datafiles - Free space

Hi,

Question :

I have a couple of tablespaces with several datafiles. Within these tablespaces is quite a bit of free space, but scattered amongst the different files, thus unuseable for creating rather large tables. So I figured there must be a way to filter out the free space left unused and reuse it for an additional datafile or a resize of an existing datafile. Easiest would seem resizing the datafiles, freeing what's left of the space inside, but within the datafiles the free space is also scattered. I could see that in DBA_FREE_SPACE.

Any hints as to how I can do this easily ?

Greets, Received on Wed Jun 07 2000 - 08:22:42 CDT