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

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <sbootsma@xxxxxxxxxxxxx>
  • Date: Thu, 16 Feb 2006 22:49:03 +0100

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: