Oracle Total Number of Records in ALL TABLES of a schema

— Note: only works if the ALL_TABLES object is up to date – read up on the ALL_TABLES first SELECT sum(num_rows) FROM all_tables WHERE owner LIKE ‘MyObjectOwnerName’