Sunday, December 28, 2008

Table Name...........Row_Count in a particular User

Getting Row_Count of all tables in a particular User


execute dbms_stats.gather_schema_stats ('scott');


select table_name, num_rows from user_tables order by table_name;

No comments:

Post a Comment