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

Home -> Community -> Usenet -> c.d.o.server -> Re: empty block vs no. freelist blocks

Re: empty block vs no. freelist blocks

From: Ben <balvey_at_comcast.net>
Date: 24 Mar 2006 07:08:47 -0800
Message-ID: <1143212927.090204.58440@u72g2000cwu.googlegroups.com> 





One other question.


If I move/rebuild these tables and indexes, would that space be
released to the tablespace or back to the datafile as unused space?
What steps would be needed to get that space back as actual OS file
space?



alter old_tablename move new_tablename new_tablespace
alter new_tablename move old_tablename old_tablespace
rebuild indexes


?
Received on Fri Mar 24 2006 - 09:08:47 CST












Original text of this message













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