If you only want an estimate, and you keep stats on your schema,
i would look at num_rows in the dba_tables view.

Or you could try a ouija board...