Re: Data Dict out of Date?

The column you are looking at only gets updated when you run an analyse for the object.
Having null for that column would indicate that the table FOO has never been analysed (or stats have been deleted).

Regards,

Neil.

Stephen Mulcahy wrote in message
<81gk4g$8br$1_at_mailint03.im.hou.compaq.com>...
>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 - 08:20:41 CST