Re: Q: What did I miss in sys.dba_tables?

shen_at_spot.Colorado.EDU (Zhijia Shen) wrote:

>Hi, Oracle gurus, please shed light on this:
 

>select owner, table_name, num_rows, blocks, ...
>from sys.dba_tables;
 

>For the results, I got values for owner and table_name. However, all the
>other columns, num_rows, blocks, ..., are null! I know that a lot of tables
>in the database are not empty. What did I miss here?

Run some statistics for the table :

analyze table TABLE_TO_BE_ANALYZED compute statistics;

This fills up the columns.

+------------------------------------------------------------+
|   Mike Philippens - Gorinchem - The Netherlands, Europe    |
|                 Vijfhart Automatisering bv                 |
|      Oracle Specialists in Training and Consultancy        |
|                 Utrecht    The Netherlands                 |
+------------------------------------------------------------+