Data Dict out of Date?

Hi,

I've been using the data dictionaries, particularly dba_tables to examine the size of our database (row counts etc.) but I came across a problem this morning basically,

select num_rows from dba_tables where table_name='FOO';

Gives me NULL.

Now, select count(*) from FOO;

Gives me 1234.

Should this inconsistency exist? I thought the data dictionaries always contained current information, or is this an invalid assumption?

Anyways comments appreciated,

-stephen

--

  Stephen Mulcahy, Compaq Customer Services, smulcahy_at_smsat.ilo.dec.com    #define disclaimer "The views expressed are the author's and do not necessarily reflect the official position of Compaq Computer Corporation" Received on Wed Nov 24 1999 - 06:02:24 CST