Oracle determine what tables have rows

To determine what tables contain row data

SELECT  table_name, num_rows
FROM    all_tables
WHERE   owner IN ('USER')
AND     num_rows > 0
ORDER BY table_name;

Leave a Reply