Re: Coelesce Tablespace in 7.2?

David R. Gilbert wrote:
>
> Is there any way to force Oracle 7.2 to coelesce a
> tablespace right away?
>
> I know it's available in 7.3, but that's not an option
> for us right now.
>
> Thanks in advance.
>
> doc_at_balr.com
>
> --
> David Gilbert Internet: doc_at_balr.com, xanadu_at_mcs.net
> Consultant BALR Corporation - Information Technologies
> Web - PERSONAL: http://www.mcs.net/~xanadu WORK: http://www.balr.com

I'm not sure about 7.2 but in 7.1.6 if you set the default pctincrease to a value > zero eg. 1 for the tablespace it will coelesce the tablespace periodically when extents are given back to free space.

dallie_at_ionet.net Received on Thu Aug 22 1996 - 00:00:00 CEST