Re: count of recs in table from dictionary
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: cichomitiko@xxxxxxxxx
- Date: Fri, 14 Oct 2005 11:35:32 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
