SQL> SELECT table_name, owner FROM all_tables where owner='CG_PROD_MYPEARSON_UPORTAL' ORDER BY owner, table_name; 2 3 4 5 6 7 TABLE_NAME OWNER ------------------------------ ------------------------------ ADMIN_TOOLS_DELTAS CG_PROD_MYPEARSON_UPORTAL PRODUCT_PICKER_DELTAS CG_PROD_MYPEARSON_UPORTAL PRODUCT_PICKER_USER CG_PROD_MYPEARSON_UPORTAL STATS_CHANNEL CG_PROD_MYPEARSON_UPORTAL STATS_EVENT CG_PROD_MYPEARSON_UPORTAL STATS_EVENT_TYPE CG_PROD_MYPEARSON_UPORTAL STATS_FOLDER CG_PROD_MYPEARSON_UPORTAL STATS_RENDER_TIME CG_PROD_MYPEARSON_UPORTAL STATS_SESSION CG_PROD_MYPEARSON_UPORTAL STATS_SESSION_GROUPS CG_PROD_MYPEARSON_UPORTAL UPC_PERM_MGR CG_PROD_MYPEARSON_UPORTAL TABLE_NAME OWNER ------------------------------ ------------------------------ UPORTAL_DELTAS CG_PROD_MYPEARSON_UPORTAL UP_CHANNEL CG_PROD_MYPEARSON_UPORTAL UP_CHANNEL_MDATA CG_PROD_MYPEARSON_UPORTAL UP_CHANNEL_PARAM CG_PROD_MYPEARSON_UPORTAL UP_CHAN_TYPE CG_PROD_MYPEARSON_UPORTAL UP_CHAN_TYPE_MDATA CG_PROD_MYPEARSON_UPORTAL UP_DLM_EVALUATOR CG_PROD_MYPEARSON_UPORTAL UP_DLM_EVALUATOR_PAREN CG_PROD_MYPEARSON_UPORTAL UP_ENTITY_CACHE_INVALIDATION CG_PROD_MYPEARSON_UPORTAL UP_ENTITY_LOCK CG_PROD_MYPEARSON_UPORTAL UP_ENTITY_PROP CG_PROD_MYPEARSON_UPORTAL TABLE_NAME OWNER ------------------------------ ------------------------------ UP_ENTITY_TYPE CG_PROD_MYPEARSON_UPORTAL UP_GROUP CG_PROD_MYPEARSON_UPORTAL UP_GROUP_MEMBERSHIP CG_PROD_MYPEARSON_UPORTAL UP_LAYOUT_PARAM CG_PROD_MYPEARSON_UPORTAL UP_LAYOUT_STRUCT CG_PROD_MYPEARSON_UPORTAL UP_LAYOUT_STRUCT_LOCALE CG_PROD_MYPEARSON_UPORTAL UP_LAYOUT_STRUCT_MDATA CG_PROD_MYPEARSON_UPORTAL UP_MIME_TYPE CG_PROD_MYPEARSON_UPORTAL UP_PERMISSION CG_PROD_MYPEARSON_UPORTAL UP_PERSON_DIR CG_PROD_MYPEARSON_UPORTAL UP_PORTLET_DEF CG_PROD_MYPEARSON_UPORTAL TABLE_NAME OWNER ------------------------------ ------------------------------ UP_PORTLET_ENT CG_PROD_MYPEARSON_UPORTAL UP_PORTLET_PREF CG_PROD_MYPEARSON_UPORTAL UP_PORTLET_PREFS CG_PROD_MYPEARSON_UPORTAL UP_PORTLET_PREF_VALUES CG_PROD_MYPEARSON_UPORTAL UP_SEQUENCE CG_PROD_MYPEARSON_UPORTAL UP_SS_MAP CG_PROD_MYPEARSON_UPORTAL UP_SS_STRUCT CG_PROD_MYPEARSON_UPORTAL UP_SS_STRUCT_PAR CG_PROD_MYPEARSON_UPORTAL UP_SS_THEME CG_PROD_MYPEARSON_UPORTAL UP_SS_THEME_PARM CG_PROD_MYPEARSON_UPORTAL UP_SS_USER_ATTS CG_PROD_MYPEARSON_UPORTAL TABLE_NAME OWNER ------------------------------ ------------------------------ UP_SS_USER_PARM CG_PROD_MYPEARSON_UPORTAL UP_USER CG_PROD_MYPEARSON_UPORTAL UP_USER_LAYOUT CG_PROD_MYPEARSON_UPORTAL UP_USER_LAYOUT_MDATA CG_PROD_MYPEARSON_UPORTAL UP_USER_LOCALE CG_PROD_MYPEARSON_UPORTAL UP_USER_MDATA CG_PROD_MYPEARSON_UPORTAL UP_USER_PARAM CG_PROD_MYPEARSON_UPORTAL UP_USER_PROFILE CG_PROD_MYPEARSON_UPORTAL UP_USER_PROFILE_LOCALE CG_PROD_MYPEARSON_UPORTAL UP_USER_PROFILE_MDATA CG_PROD_MYPEARSON_UPORTAL UP_USER_UA_MAP CG_PROD_MYPEARSON_UPORTAL TABLE_NAME OWNER ------------------------------ ------------------------------ UP_VERSIONS CG_PROD_MYPEARSON_UPORTAL 56 rows selected. SQL> SQL> SQL> SQL> select count(1) from PRODUCT_PICKER_USER; COUNT(1) ---------- 83899 SQL>