Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Feb 16 2006 - 15:49:03 CST