Re: Data Dict out of Date?

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Wed, 24 Nov 1999 15:49:08 GMT
Message-ID: <81h1di$ufi$1@nnrp1.deja.com>

So could FOO be a view (won't be in DBA_TABLES) or maybe it could be a synonym (ditto on DBA_TABLES)? Try "SELECT * FROM dba_objects WHERE object_name='FOO';"; this will tell you what FOO really is.

HTH
James

In article <81gk4g$8br$1_at_mailint03.im.hou.compaq.com>, Stephen Mulcahy <smulcahy_at_ebola.ilo.dec.com> wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 09:49:08 CST