select table_name,num_rows from dba_tables where num_rows >100000

(if you analyze your tables regularly then only you can get the correct
result) as with every analysis it updates the num_rows of the table in
dba_Tables view

Parveen

Yogesh Bhamre wrote:
> Hi all,
>
>
>
>
>
> How to find out top tables which has more than 1,00,000 rows exists in
> the database?
>
>
>
> Please advice forward path.
>
>
>
> Regards,
>
> Yogesh Bhamre
>
>
>
> Disclaimer: Information transmitted by this e-mail is proprietary to Adventity and/ or its Customers, intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [Email address protected] and delete this mail from your records.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


--




Parveen Kumar
Database Administrator
Level 3
28,Clarendon Street
South Melbourne
Victoria -3205
+61 (3) 96747010
+61 (0) 404-851-874
-------------------
Ekit.com
-------------------

Oracle LazyDBA home page