1. SQL> SELECT
2.   table_name, owner
3. FROM
4.   all_tables
5. where owner='CG_PROD_MYPEARSON_APP'
6. ORDER BY
7.   owner, table_name;
8.   2    3    4    5    6    7  
9. TABLE_NAME                     OWNER
10. ------------------------------ ------------------------------
11. CLASS_ROSTER                   CG_PROD_MYPEARSON_APP
12. CLASS_ROSTER_PRODUCT           CG_PROD_MYPEARSON_APP
13. CLASS_ROSTER_USER              CG_PROD_MYPEARSON_APP
14. COURSE_SERVICES_DELTAS         CG_PROD_MYPEARSON_APP
15.  
16. SQL>
17. SQL>
18. SQL> select count(1) from CLASS_ROSTER;
19.  
20.   COUNT(1)
21. ----------
22.      58155
23.  
24. SQL> select count(1) from CLASS_ROSTER_USER;
25.  
26.   COUNT(1)
27. ----------
28.     717084
29.  
30. SQL> select count(1) from CLASS_ROSTER_PRODUCT;
31.  
32.   COUNT(1)
33. ----------
34.      76953
35.  
36. SQL>