Re: difference in dba_tables and dba_segments??

On Tue, 20 Jun 2006 07:58:45 -0700, Ben wrote:

> I'd rather use dba_table instead of joining between the two to get
> num_rows, last_analyzed, and size values, but if these are returning
> different values how do I know which one is correct?
> Thank you,

Very simple: go through DBA_EXTENTS and sum up sizes of all extents comprising the table. See which number will you get. My guess is that the number will be the one from DBA_SEGMENTS for the reason mentioned by Brian.

-- 
http://www.mgogala.com