coalescing free space
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/01/18
Message-ID: <4dlqbf$k5c_at_ixnews8.ix.netcom.com>#1/1
Date: 1996/01/18
Message-ID: <4dlqbf$k5c_at_ixnews8.ix.netcom.com>#1/1
I remember reading somewhere that oracle is supposed to automatically coalesce free space if the blocks are contiguous. In other words if I have 3 10m spaces in the same datafile that are immediately next to each other, it's supposed to create one 30m space out of it. Does this work correctly in version 7.1? I have just such a situation but it never seems to coalesce the space. I even tried creating a 30m table in that datafile thinking that maybe it only happens when you create an object, but it didn't do it then either. What do I need to do to coalesce the space, short of recreating the tablespace?
-- Chuck Hamilton chuckh_at_ix.netcom.com If at first you don't succeed, skydiving isn't for you.Received on Thu Jan 18 1996 - 00:00:00 CET