Oracle determine what tables have rows Posted on May 16, 2012 by torrancejones 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;