Counting number of rows
select table_name from dba_tables where owner ='OWNERNAME';
to get the tables. Then put them in the first column of a spreadsheet. In the second column, add this formula:
="select '"&A1&"' as Tbl, count(*) as Cnt from CORE."&A1
and in the third column put “UNION”, except for the last row, that gets a “;”
Ta-da! Ready to run.