Re: count of recs in table from dictionary

Manoj,

> > I do not have select access to actual table.
> Analyze the table, query dba_tables.num_rows.

If you don't want to analyze the table as Dimitre suggests, you can check the LAST_ANALYZED column on either dba_tables or all_tables to see when the table was last analyzed and you can decided if the information is recent enough for your purposes.

   Although, if the table owner doesn't want to give you select access, then you are probably out of luck in any case.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l