Home -> Usenet -> comp.databases.oracle -> NUM_ROWS in DBA_TABLES has no values

NUM_ROWS in DBA_TABLES has no values

From: Karl Penney <aa651_at_ccn.cs.dal.ca>
Date: 1995/05/26
Message-ID: <D97981.BH2_at_cs.dal.ca>#1/1 






I was trying to write a query to find the number of rows in some
tables using the NUM_ROWS field on the dictionary table DBA_TABLES
but all the values are blank.  I can't use count(*) on the tables
themselves because I need to join the results to some other dictionary
tables to get other info.  Why is the NUM_ROWS field blank and how can
I get is populated with real data.


--
Karl Penney                           |~~~~~~|     _/^\_     |~~~~~~|
DMR Group, Halifax, NS                |      | _/\_\   /_/\_ |      |
aa651_at_cfn.cs.dal.ca                   |      | >___________< |      |
74203.673_at_compuserve.com              |______|       |       |______|


Received on Fri May 26 1995 - 00:00:00 CEST












Original text of this message