dbms_space.unused_space .
re analyze the table will change the num_rows in dba_tables .
"GAURAV MITTAL" <gaurav82online_at_yahoo.com> wrote in message
news:4329cc8c.0304260657.d37c66f_at_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 - 10:09:15 CDT
