Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Datafiles - Free space

Datafiles - Free space

From: Weerd de E.C. Kirsten <Kirsten.deWeerd_at_Oranjewoud.nl>
Date: Wed, 7 Jun 2000 14:22:42 +0100
Message-Id: <10521.108031@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US