If the tables are (recently) analyzed:
SELECT table_name, num_rows FROM user_tables;