Q: What did I miss in sys.dba_tables?

Hi, Oracle gurus, please shed light on this:

I want to see how many rows and other information related to the tables in our database by querying sys.dba_tables. The query is as simple as 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?

Thanks for your help. Received on Wed Sep 27 1995 - 00:00:00 CET