Xref: alice comp.databases.oracle.server:75365
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!btnet-peer!btnet-feed2!btnet!bt !not-for-mail
From: "Neil" <plums@bigfoot.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Data Dict out of Date?
Date: Wed, 24 Nov 1999 14:18:25 -0000
Organization: bibbly bobbly boo
Lines: 35
Message-ID: <81gs5c$oaq$1@pheidippides.axion.bt.co.uk>
References: <81gk4g$8br$1@mailint03.im.hou.compaq.com>
X-Trace: pheidippides.axion.bt.co.uk 943453164 24922 147.147.57.116 (24 Nov 1999 14:19:24 GMT)
X-Complaints-To: postmaster@axion.bt.co.uk
NNTP-Posting-Date: 24 Nov 1999 14:19:24 GMT
X-Newsreader:  Microsoft Outlook Express 4.72.2106.4
X-Mimeole:  Produced By Microsoft MimeOLE V4.72.2106.4

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@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@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"