Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Packing or freeing datafiles?

Re: Packing or freeing datafiles?

From: <yong321_at_yahoo.com>
Date: 4 May 2005 11:06:23 -0700
Message-ID: <1115229983.537803.288800@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 - 13:06:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US