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

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

RE: Datafiles - Free space

From: Klavers, Richard <R.Klavers_at_arbeidsbureau.nl>
Date: Wed, 7 Jun 2000 15:40:58 +0200
Message-Id: <10521.108040@fatcity.com>


Kirsten,

I should try Export/Drop/Create/Import. Then you will loose the free gaps between tables.

Regards, Richard Klavers

Tel.: 00 31 (0)79 371 2543
Fax: 00 31 (0)79 371 2529
E-mail: r.klavers_at_arbeidsbureau.nl

> ----------
> Van: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: woensdag 7 juni 2000 15:40
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: 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,
>
>
> Kirsten
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 07 2000 - 08:40:58 CDT

Original text of this message

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