Re: Packing or freeing datafiles?

From: <yong321_at_yahoo.com>
Date: 4 May 2005 11:06:23 -0700
Message-ID: <1115229983.537803.288800_at_f14g2000cwb.googlegroups.com>


Other than moving it to a new tablespace (as Matthias says), run "alter table move" once. Assuming your tablespace is LMT, the table blocks should migrate toward the beginning of the file. (Ref. Jonathan Lewis, "Practical Oracle8i", pp.153-4)

It seems that when you do it again, or more correctly, even number of times, the blocks migrate back.

Yong Huang Received on Wed May 04 2005 - 20:06:23 CEST

Original text of this message