WHATS WRONG WITH DBA_TABLES?
From: Charles Walker <cwalker_at_explorer.csc.com>
Date: 1996/04/16
Message-ID: <3173E4DF.1413_at_explorer.csc.com>#1/1
Date: 1996/04/16
Message-ID: <3173E4DF.1413_at_explorer.csc.com>#1/1
When I run the following I get no rows
SQL> SELECT NUM_ROWS FROM SYS.DBA_TABLES WHERE TABLE_NAME ='NEW_MARINES'; NUM_ROWS
But when I do a count I get rows...whats up? I am logged in as a DBA.
SQL> SELECT COUNT(*) FROM TFDSS.NEW_MARINES; COUNT(*)
569438 Received on Tue Apr 16 1996 - 00:00:00 CEST