Yes, it is, but the implementation of this functtion is defferent in different Oracle version, and may have different effect. Aslo note that the COALESCE FREE SSPACE just initiates the process either by using ALTER TABLESPACE... COALESCE in Oracle 8 or or ALTER SESSION SET EVENT ... in Oracle 7. Oracle doesn ot guarantee that the free space will be coalesced in one continuous segment : Is functional button COALESCE FREE SPACE NOW in trial version DB Tools : 3.2.0.2?
|