Oracle determine what tables have rows

To determine what tables contain row data

1
2
3
4
5

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