Re: count of recs in table from dictionary

This procedure is running from SYS schema. I think he should be able to do that as a DBA.
 Right ??? Can you block SYS to do the selects???  Regards - Chirag

 On 10/15/05, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> Real nice, but totally irrelevant. The OP clearly stated "I do not
> have select access to actual table"
>
> At 09:54 AM 10/15/2005, Chirag DBA wrote:
> >We often need to produce record counts of the particular schema.
> >
> >Create this procedure, change it as per yr requirements.
> >right now I am inserting rowcounts in a table with timestamp.
> >
> >
> >Regards - Chirag
> >On 10/14/05, Dennis Williams
> ><<mailto:oracledba.williams_at_gmail.com>oracledba.williams_at_gmail.com>
> wrote:
> >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>
> http://www.freelists.org/webpage/oracle-l
> >
> >
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> http://www.centrexcc.com
>
>
>

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