Re: defragmenting free space in a tablespace
From: Stephen L. O'Hearn <soh1_at_ix.netcom.com>
Date: 1995/10/30
Message-ID: <472o2k$e36_at_ixnews7.ix.netcom.com>#1/1
Date: 1995/10/30
Message-ID: <472o2k$e36_at_ixnews7.ix.netcom.com>#1/1
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