Re: defragmenting free space in a tablespace

In Article<472o2k$e36_at_ixnews7.ix.netcom.com>, <soh1_at_ix.netcom.com> write:
> Path: gate.net!news.sprintlink.net!newsfeed.internetmci.com!howland.reston.ans.net!ix.netcom.com!netnews
> From: soh1_at_ix.netcom.com (Stephen L. O'Hearn )
> Newsgroups: comp.databases.oracle
> Subject: Re: defragmenting free space in a tablespace
> Date: 30 Oct 1995 14:39:16 GMT
> Organization: Netcom
> Lines: 17
> Message-ID: <472o2k$e36_at_ixnews7.ix.netcom.com>
> References: <472njo$eev_at_ixnews6.ix.netcom.com>
> NNTP-Posting-Host: ix-dc8-06.ix.netcom.com
> X-NETCOM-Date: Mon Oct 30 6:39:16 AM PST 1995
>
> In <472njo$eev_at_ixnews6.ix.netcom.com> chuckh_at_ix.netcom.com (Chuck
> Hamilton) writes:
> >
> >How does one condense all the free spaces in a tablespace into one big
> >contiguous free space?
> >--
> >Chuck Hamilton
> >chuckh_at_ix.netcom.com
> >
> >Incoming fire has the right of way!
> >
>
> I believe you have to do an EXPort, drop the tables (making note of
> your grants first), then do an IMPort. This should clean up
> everything.
>
> - Steve O'Hearn

Oracle V7 takes care of this itself. For V6, creating a dummy tables of the appropriate sizes to occupy the free space will force the database to re-combine _adjacent_ free spaces. I have a Pro*C program that will accomplish this for all available tablespaces, if you desire. Contact me via E-mail for a MIME or UUE copy. I use this tool every time I drop any tables. It has greatly increased the time between exports for me.

Steve. Received on Wed Nov 01 1995 - 00:00:00 CET