SQL> SELECT table_name, owner FROM all_tables where owner='CG_PROD_MYPEARSON_APP' ORDER BY owner, table_name; 2 3 4 5 6 7 TABLE_NAME OWNER ------------------------------ ------------------------------ CLASS_ROSTER CG_PROD_MYPEARSON_APP CLASS_ROSTER_PRODUCT CG_PROD_MYPEARSON_APP CLASS_ROSTER_USER CG_PROD_MYPEARSON_APP COURSE_SERVICES_DELTAS CG_PROD_MYPEARSON_APP SQL> SQL> SQL> select count(1) from CLASS_ROSTER; COUNT(1) ---------- 58155 SQL> select count(1) from CLASS_ROSTER_USER; COUNT(1) ---------- 717084 SQL> select count(1) from CLASS_ROSTER_PRODUCT; COUNT(1) ---------- 76953 SQL>