Re: Packing or freeing datafiles?

If the table starts at the beginning of the datafile then moving it once won't work, but if you move it twice then it should definitely work.

Also, in regards to indexes, I've found that you should rebuild them into another tablespace and then maybe rebuild them back into the original tablespace if needed, however leaving them in the new tablespace would be quicker if that isn't a problem for you.

Ideally you should just reverse engineer your indexes, then drop them and recreate them (if possible). This is harder than moving them twice, but twice as quick. I guess it depends on whether you need to have them online at all times.

yong321_at_yahoo.com wrote:
> 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 - 19:19:01 CDT