Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Dict out of Date?
if FOO were a view it wouldn't show in dba_tables but would be in dba_views
HTH NeilC
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:18:25 CST