Another idea.

Take a look at ALL_TABLES.

SELECT TABLE_NAME, NUM_ROWS
FROM ALL_TABLES
WHERE OWNER NOT IN ('SYS','SYSTEM');

As far as I know this method only works if the tables are ANALYZED.

Ben