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 -> UNUSED SPACE IN TABLE

UNUSED SPACE IN TABLE

From: GAURAV MITTAL <gaurav82online_at_yahoo.com>
Date: 26 Apr 2003 07:57:01 -0700
Message-ID: <4329cc8c.0304260657.d37c66f@posting.google.com> 





how do i find the unused space in a table.actually my table contained
7.8 million records.i deleted 4 million records.the count(*) on the
table shows 3.8 million records.However when i queried the num_rows in
dba_tables it showed 7.8 million rows.


           also the space occupied before delete was fired showed 50
gigs in the bytes column in dba_tables and the same was showed in the
dba_tables(bytes column) after the delete was done.



does anybody have anwser??
Received on Sat Apr 26 2003 - 09:57:01 CDT












Original text of this message













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