NUM_ROWS in DBA_TABLES

[theresatan]

Hi:

In my oracle server9.2
The num_rows field in dictionary table--dba_tables(or all_tables)did not return row count for some of the the tables and I knew that table has data(select count(*) from tbl1, return 100 rows).

Do you know why?Any way can fix it? Or any alternate table I can use instead of dba_tables?

Thanks!

Theresa

 

[Turkbear]

Hi,
Analyze the table(s) to generate the statistics needed to populate that field.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[theresatan]

It works perfectly!

Thanks,Turkbear!

Theresa

 

[SantaMufasa]

Theresa,

When "It works perfectly", it is always a good policy on Tek-Tips to press the link on his post that says, "Thank Turkbear for this valuable post!"

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]