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 -> Oracle 8i rebuilding index caused change in used space of datafile(in which tables reside)

Oracle 8i rebuilding index caused change in used space of datafile(in which tables reside)

From: Roop <rupinder99_at_hotmail.com>
Date: Tue, 9 Nov 2004 19:55:23 -0500
Message-ID: <5Gdkd.69694$QQ5.1375356@weber.videotron.net> 





Hello


         I have separate tablespaces for indexes and tables. I have rebuild
the indexes and it has changed the used space of index1.dbf file but at the
same time it has also changed the used space of datafile in which the tables
data reside. I have checked in DBA studio that the percentage used for the
datafile in which the tables reside has dropped from 90% to 70% used.  Is it
normal when we rebuild indexes that it cleans the unused space in the
datafile in which the tables reside or what could be another reason behind
this?




Thank you in advance
Received on Tue Nov 09 2004 - 18:55:23 CST












Original text of this message













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