Re: count of recs in table from dictionary

Analyze the table, query dba_tables.num_rows.

Cheers,
Dimitre Radoulov

• Original Message ----- From: <manoj.gurnani_at_polaris.co.in> To: <oracle-l_at_freelists.org> Sent: Friday, October 14, 2005 8:32 AM Subject: count of recs in table from dictionary

>
>
>
>
>
> Hi,
> How can get the no of rows in a table from a dictionary table.
> I do not have select access to actual table.
>
> Thanks
> Manoj
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only.
> If by an addressing or transmission error this mail has been misdirected
> to you, you are requested to delete this mail immediately.
> You are also hereby notified that any use, any form of reproduction,
> dissemination, copying, disclosure, modification,
> distribution and/or publication of this e-mail message, contents or its
> attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit Us at http://www.polaris.co.in
> --
> http://www.freelists.org/webpage/oracle-l

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