Sunday, February 23, 2014

oracle count tables rows for multiple tables

http://stackoverflow.com/questions/4323961/crosspost-wordpress-blog-post-to-blogger

SELECT table_name,
       num_rows
  FROM ALL_TABLES a
WHERE TABLE_NAME like 'MDA%'
AND OWNER='MDM_DEV2'
order by table_name;
 

This command can refresh the statistics in the ALL_TABLES
exec dbms_stats.gather_schema_stats('MDM_DEV2');

No comments:

Post a Comment