RE: DBA_TABLES.NUMROWS not equal Count(*) ... Why?

Sam

>SQL> exec dbms_stats.set_table_stats('GENERAL','GUROUTP');

With this command Oracle sets some default values. You have to use 
dbms_stats.gather_table_stats instead...


HTH
Chris

--
http://www.freelists.org/webpage/oracle-l


Other related posts: