Re: WHATS WRONG WITH DBA_TABLES?

Charles Walker wrote:
> 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

Row counts are only populated after you have gathered statistics for a table. It doesn't matter whether you compute or estimate when you analyze, but you must do it in order to get row counts. Issue the statement, "analyze table new_marines compute statistics" and then check for row counts.

-- 
James A. Mumper
Senior Oracle DBA
Pacific Telesis Video Services