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’

Tagged: all tables, all_tables, Oracle, record count

Posted in: Oracle, PL/SQL, SQL