Oracle PL/SQL/System Tables Views/ALL TABLES — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
| |
Версия 16:45, 26 мая 2010
Get all tables that you have been granted access to
<source lang="sql">
SQL> SQL> --Get all tables that you have been granted access to, SQL> --including the tables that you own: SQL> SQL> SELECT owner, table_name FROM ALL_TABLES ORDER BY owner, table_name; OWNER TABLE_NAME
------------------------------
CTXSYS DR$CLASS CTXSYS DR$DBO CTXSYS DR$DELETE CTXSYS DR$INDEX CTXSYS DR$INDEX_ERROR CTXSYS DR$INDEX_OBJECT CTXSYS DR$INDEX_PARTITION CTXSYS DR$INDEX_SET CTXSYS DR$INDEX_SET_INDEX CTXSYS DR$INDEX_VALUE CTXSYS DR$NUMBER_SEQUENCE OWNER TABLE_NAME
------------------------------
CTXSYS DR$NVTAB CTXSYS DR$OBJECT CTXSYS DR$OBJECT_ATTRIBUTE CTXSYS DR$OBJECT_ATTRIBUTE_LOV CTXSYS DR$ONLINE_PENDING CTXSYS DR$PARALLEL CTXSYS DR$PARAMETER CTXSYS DR$PENDING CTXSYS DR$POLICY_TAB CTXSYS DR$PREFERENCE CTXSYS DR$PREFERENCE_VALUE OWNER TABLE_NAME
------------------------------
CTXSYS DR$SECTION CTXSYS DR$SECTION_GROUP CTXSYS DR$SQE CTXSYS DR$STATS CTXSYS DR$STOPLIST CTXSYS DR$STOPWORD CTXSYS DR$SUB_LEXER CTXSYS DR$THS CTXSYS DR$THS_BT CTXSYS DR$THS_FPHRASE CTXSYS DR$THS_PHRASE OWNER TABLE_NAME
------------------------------
CTXSYS DR$UNINDEXED CTXSYS DR$WAITING CTXSYS SYS_IOT_OVER_9700 CTXSYS SYS_IOT_OVER_9745 DBSNMP MGMT_BASELINE DBSNMP MGMT_BASELINE_SQL DBSNMP MGMT_BSLN_BASELINES DBSNMP MGMT_BSLN_DATASOURCES DBSNMP MGMT_BSLN_INTERVALS DBSNMP MGMT_BSLN_METRICS DBSNMP MGMT_BSLN_RAWDATA OWNER TABLE_NAME
------------------------------
DBSNMP MGMT_BSLN_STATISTICS DBSNMP MGMT_BSLN_THRESHOLD_PARMS DBSNMP MGMT_CAPTURE DBSNMP MGMT_CAPTURE_SQL DBSNMP MGMT_DB_FILE_GTT DBSNMP MGMT_DB_SIZE_GTT DBSNMP MGMT_HISTORY DBSNMP MGMT_HISTORY_SQL DBSNMP MGMT_LATEST DBSNMP MGMT_LATEST_SQL DBSNMP MGMT_RESPONSE_CONFIG OWNER TABLE_NAME
------------------------------
DBSNMP MGMT_SNAPSHOT DBSNMP MGMT_SNAPSHOT_SQL DBSNMP MGMT_TEMPT_SQL FLOWS_020100 SYS_IOT_OVER_12581 FLOWS_020100 WWV_COLUMN_EXCEPTIONS FLOWS_020100 WWV_FLOWS FLOWS_020100 WWV_FLOWS_RESERVED FLOWS_020100 WWV_FLOW_ACTIVITY_LOG1$ FLOWS_020100 WWV_FLOW_ACTIVITY_LOG2$ FLOWS_020100 WWV_FLOW_ACTIVITY_LOG_NUMBER$ FLOWS_020100 WWV_FLOW_ALTERNATE_CONFIG OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_ALT_CONFIG_DETAIL FLOWS_020100 WWV_FLOW_ALT_CONFIG_PICK FLOWS_020100 WWV_FLOW_APPLICATION_TABS FLOWS_020100 WWV_FLOW_APPLICATION_TAB_SETS FLOWS_020100 WWV_FLOW_BANNER FLOWS_020100 WWV_FLOW_BUILDER_AUDIT_TRAIL FLOWS_020100 WWV_FLOW_BUTTON_TEMPLATES FLOWS_020100 WWV_FLOW_CALS FLOWS_020100 WWV_FLOW_CAL_TEMPLATES FLOWS_020100 WWV_FLOW_CHARSETS FLOWS_020100 WWV_FLOW_CLICKTHRU_LOG$ OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_CLICKTHRU_LOG2$ FLOWS_020100 WWV_FLOW_CLICKTHRU_LOG_NUMBER$ FLOWS_020100 WWV_FLOW_COLLECTIONS$ FLOWS_020100 WWV_FLOW_COLLECTION_MEMBERS$ FLOWS_020100 WWV_FLOW_COMPANIES FLOWS_020100 WWV_FLOW_COMPANY_SCHEMAS FLOWS_020100 WWV_FLOW_COMPANY_TYPES FLOWS_020100 WWV_FLOW_COMPOUND_CONDITIONS FLOWS_020100 WWV_FLOW_COMPUTATIONS FLOWS_020100 WWV_FLOW_COUNTRIES FLOWS_020100 WWV_FLOW_CSS_REPOSITORY OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_CUSTOMIZED_TASKS FLOWS_020100 WWV_FLOW_CUSTOM_AUTH_SETUPS FLOWS_020100 WWV_FLOW_DATA FLOWS_020100 WWV_FLOW_DATA_LOAD_BAD_LOG FLOWS_020100 WWV_FLOW_DATA_LOAD_UNLOAD FLOWS_020100 WWV_FLOW_DB_AUTH FLOWS_020100 WWV_FLOW_DEVELOPERS FLOWS_020100 WWV_FLOW_DEVELOPER_ROLES FLOWS_020100 WWV_FLOW_DICTIONARY$ FLOWS_020100 WWV_FLOW_DUAL100 FLOWS_020100 WWV_FLOW_DYNAMIC_TRANSLATIONS$ OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_EFFECTIVE_USERID_MAP FLOWS_020100 WWV_FLOW_ENTRY_POINTS FLOWS_020100 WWV_FLOW_ENTRY_POINT_ARGS FLOWS_020100 WWV_FLOW_FEEDBACK FLOWS_020100 WWV_FLOW_FIELD_TEMPLATES FLOWS_020100 WWV_FLOW_FILE_OBJECTS$PART FLOWS_020100 WWV_FLOW_FND_GROUP_USERS FLOWS_020100 WWV_FLOW_FND_USER FLOWS_020100 WWV_FLOW_FND_USER_GROUPS FLOWS_020100 WWV_FLOW_HNT_ARGUMENT_INFO FLOWS_020100 WWV_FLOW_HNT_COLUMN_INFO OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_HNT_LOV_DATA FLOWS_020100 WWV_FLOW_HNT_PROCEDURE_INFO FLOWS_020100 WWV_FLOW_HNT_TABLE_INFO FLOWS_020100 WWV_FLOW_HTML_REPOSITORY FLOWS_020100 WWV_FLOW_ICON_BAR FLOWS_020100 WWV_FLOW_ICON_BAR_ATTRIBUTES FLOWS_020100 WWV_FLOW_IMAGE_REPOSITORY FLOWS_020100 WWV_FLOW_IMPORT_EXPORT FLOWS_020100 WWV_FLOW_ITEMS FLOWS_020100 WWV_FLOW_JOBS FLOWS_020100 WWV_FLOW_JOB_BIND_VALUES OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_LANGUAGES FLOWS_020100 WWV_FLOW_LANGUAGE_MAP FLOWS_020100 WWV_FLOW_LISTS FLOWS_020100 WWV_FLOW_LISTS_OF_VALUES$ FLOWS_020100 WWV_FLOW_LIST_ITEMS FLOWS_020100 WWV_FLOW_LIST_OF_VALUES_DATA FLOWS_020100 WWV_FLOW_LIST_TEMPLATES FLOWS_020100 WWV_FLOW_LOCK_PAGE FLOWS_020100 WWV_FLOW_LOCK_PAGE_LOG FLOWS_020100 WWV_FLOW_LOV_TEMP FLOWS_020100 WWV_FLOW_LOV_VALUES OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_MAIL_LOG FLOWS_020100 WWV_FLOW_MAIL_QUEUE FLOWS_020100 WWV_FLOW_MENUS FLOWS_020100 WWV_FLOW_MENU_OPTIONS FLOWS_020100 WWV_FLOW_MENU_TEMPLATES FLOWS_020100 WWV_FLOW_MESSAGES$ FLOWS_020100 WWV_FLOW_MODELS FLOWS_020100 WWV_FLOW_MODEL_PAGES FLOWS_020100 WWV_FLOW_MODEL_PAGE_COLS FLOWS_020100 WWV_FLOW_ONLINE_HELP FLOWS_020100 WWV_FLOW_ONLINE_HELP_JA OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_PAGES_RESERVED FLOWS_020100 WWV_FLOW_PAGE_GENERIC_ATTR FLOWS_020100 WWV_FLOW_PAGE_GROUPS FLOWS_020100 WWV_FLOW_PAGE_PLUGS FLOWS_020100 WWV_FLOW_PAGE_PLUG_TEMPLATES FLOWS_020100 WWV_FLOW_PAGE_SUBMISSIONS FLOWS_020100 WWV_FLOW_PATCHES FLOWS_020100 WWV_FLOW_PICK_DATABASE_SIZE FLOWS_020100 WWV_FLOW_PICK_END_USERS FLOWS_020100 WWV_FLOW_PICK_PAGE_VIEWS FLOWS_020100 WWV_FLOW_PLATFORM_PREF OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_PLATFORM_PREFS FLOWS_020100 WWV_FLOW_POPUP_LOV_TEMPLATE FLOWS_020100 WWV_FLOW_PREFERENCES$ FLOWS_020100 WWV_FLOW_PROCESSING FLOWS_020100 WWV_FLOW_PROVISION_COMPANY FLOWS_020100 WWV_FLOW_PROVISION_SERICE_MOD FLOWS_020100 WWV_FLOW_PURGED_SESSIONS$ FLOWS_020100 WWV_FLOW_QB_SAVED_COND FLOWS_020100 WWV_FLOW_QB_SAVED_JOIN FLOWS_020100 WWV_FLOW_QB_SAVED_QUERY FLOWS_020100 WWV_FLOW_QB_SAVED_TABS OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_QUERY_COLUMN FLOWS_020100 WWV_FLOW_QUERY_CONDITION FLOWS_020100 WWV_FLOW_QUERY_DEFINITION FLOWS_020100 WWV_FLOW_QUERY_OBJECT FLOWS_020100 WWV_FLOW_REGION_CHART_SER_ATTR FLOWS_020100 WWV_FLOW_REGION_REPORT_COLUMN FLOWS_020100 WWV_FLOW_REGION_REPORT_FILTER FLOWS_020100 WWV_FLOW_REGION_UPD_RPT_COLS FLOWS_020100 WWV_FLOW_REQUIRED_ROLES FLOWS_020100 WWV_FLOW_RESTRICTED_SCHEMAS FLOWS_020100 WWV_FLOW_ROW_TEMPLATES OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_RSCHEMA_EXCEPTIONS FLOWS_020100 WWV_FLOW_SC_TRANS FLOWS_020100 WWV_FLOW_SECURITY_SCHEMES FLOWS_020100 WWV_FLOW_SESSIONS$ FLOWS_020100 WWV_FLOW_SHARED_WEB_SERVICES FLOWS_020100 WWV_FLOW_SHORTCUTS FLOWS_020100 WWV_FLOW_SHORTCUT_USAGE_MAP FLOWS_020100 WWV_FLOW_STEPS FLOWS_020100 WWV_FLOW_STEP_BRANCHES FLOWS_020100 WWV_FLOW_STEP_BRANCH_ARGS FLOWS_020100 WWV_FLOW_STEP_BUTTONS OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_STEP_COMPUTATIONS FLOWS_020100 WWV_FLOW_STEP_ITEMS FLOWS_020100 WWV_FLOW_STEP_ITEM_HELP FLOWS_020100 WWV_FLOW_STEP_PROCESSING FLOWS_020100 WWV_FLOW_STEP_VALIDATIONS FLOWS_020100 WWV_FLOW_SW_BINDS FLOWS_020100 WWV_FLOW_SW_CREATE_KEYWORDS FLOWS_020100 WWV_FLOW_SW_DETAIL_RESULTS FLOWS_020100 WWV_FLOW_SW_MAIN_KEYWORDS FLOWS_020100 WWV_FLOW_SW_RESULTS FLOWS_020100 WWV_FLOW_SW_SET_KEYWORDS OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_SW_SQLPLUS_CMD FLOWS_020100 WWV_FLOW_SW_SQL_CMDS FLOWS_020100 WWV_FLOW_SW_STMTS FLOWS_020100 WWV_FLOW_TABS FLOWS_020100 WWV_FLOW_TEMPLATES FLOWS_020100 WWV_FLOW_TEMPLATES$ FLOWS_020100 WWV_FLOW_TEMPLATE_PREFERENCES FLOWS_020100 WWV_FLOW_TEMPLATE_THEMES$ FLOWS_020100 WWV_FLOW_TEMP_TABLE FLOWS_020100 WWV_FLOW_TEMP_TREES FLOWS_020100 WWV_FLOW_THEMES OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_TOPLEVEL_TABS FLOWS_020100 WWV_FLOW_TRANSLATABLE_COLS$ FLOWS_020100 WWV_FLOW_TRANSLATABLE_TEXT$ FLOWS_020100 WWV_FLOW_TREES FLOWS_020100 WWV_FLOW_TREE_STATE FLOWS_020100 WWV_FLOW_UPGRADE_PROGRESS FLOWS_020100 WWV_FLOW_UPG_COL_NAME_CHANGES FLOWS_020100 WWV_FLOW_UPG_TAB_NAME_CHANGES FLOWS_020100 WWV_FLOW_UPG_TAB_OBSOLETE FLOWS_020100 WWV_FLOW_VERSION$ FLOWS_020100 WWV_FLOW_WS_OPERATIONS OWNER TABLE_NAME
------------------------------
FLOWS_020100 WWV_FLOW_WS_PARAMETERS FLOWS_020100 WWV_FLOW_WS_PROCESS_PARMS_MAP FLOWS_FILES WWV_FLOW_FILE_OBJECTS$ HR COUNTRIES HR DEPARTMENTS HR EMPLOYEES HR JOBS HR JOB_HISTORY HR LOCATIONS HR REGIONS MDSYS MD$RELATE OWNER TABLE_NAME
------------------------------
MDSYS OGIS_GEOMETRY_COLUMNS MDSYS OGIS_SPATIAL_REFERENCE_SYSTEMS MDSYS SDO_COORD_AXES MDSYS SDO_COORD_AXIS_NAMES MDSYS SDO_COORD_OPS MDSYS SDO_COORD_OP_METHODS MDSYS SDO_COORD_OP_PARAMS MDSYS SDO_COORD_OP_PARAM_USE MDSYS SDO_COORD_OP_PARAM_VALS MDSYS SDO_COORD_OP_PATHS MDSYS SDO_COORD_REF_SYS OWNER TABLE_NAME
------------------------------
MDSYS SDO_COORD_SYS MDSYS SDO_CS_SRS MDSYS SDO_DATUMS MDSYS SDO_DATUMS_OLD_SNAPSHOT MDSYS SDO_ELLIPSOIDS MDSYS SDO_ELLIPSOIDS_OLD_SNAPSHOT MDSYS SDO_GEOM_METADATA_TABLE MDSYS SDO_INDEX_METADATA_TABLE MDSYS SDO_LRS_METADATA_TABLE MDSYS SDO_MAPS_TABLE MDSYS SDO_PREFERRED_OPS_SYSTEM OWNER TABLE_NAME
------------------------------
MDSYS SDO_PREFERRED_OPS_USER MDSYS SDO_PRIME_MERIDIANS MDSYS SDO_PROJECTIONS_OLD_SNAPSHOT MDSYS SDO_STYLES_TABLE MDSYS SDO_THEMES_TABLE MDSYS SDO_TOPO_DATA$ MDSYS SDO_TOPO_MAPS MDSYS SDO_TOPO_METADATA_TABLE MDSYS SDO_TOPO_RELATION_DATA MDSYS SDO_TOPO_TRANSACT_DATA MDSYS SDO_TXN_IDX_DELETES OWNER TABLE_NAME
------------------------------
MDSYS SDO_TXN_IDX_EXP_UPD_RGN MDSYS SDO_TXN_IDX_INSERTS MDSYS SDO_UNITS_OF_MEASURE OUTLN OL$ OUTLN OL$HINTS OUTLN OL$NODES SYS ACCESS$ SYS ALERT_QT SYS APPLY$_CONF_HDLR_COLUMNS SYS APPLY$_CONSTRAINT_COLUMNS SYS APPLY$_DEST_OBJ OWNER TABLE_NAME
------------------------------
SYS APPLY$_DEST_OBJ_CMAP SYS APPLY$_DEST_OBJ_OPS SYS APPLY$_ERROR SYS APPLY$_ERROR_HANDLER SYS APPLY$_ERROR_TXN SYS APPLY$_SOURCE_OBJ SYS APPLY$_SOURCE_SCHEMA SYS APPLY$_VIRTUAL_OBJ_CONS SYS APPROLE$ SYS AQ$_ALERT_QT_G SYS AQ$_ALERT_QT_H OWNER TABLE_NAME
------------------------------
SYS AQ$_ALERT_QT_I SYS AQ$_ALERT_QT_S SYS AQ$_ALERT_QT_T SYS AQ$_AQ$_MEM_MC_G SYS AQ$_AQ$_MEM_MC_H SYS AQ$_AQ$_MEM_MC_I SYS AQ$_AQ$_MEM_MC_S SYS AQ$_AQ$_MEM_MC_T SYS AQ$_KUPC$DATAPUMP_QUETAB_G SYS AQ$_KUPC$DATAPUMP_QUETAB_H SYS AQ$_KUPC$DATAPUMP_QUETAB_I OWNER TABLE_NAME
------------------------------
SYS AQ$_KUPC$DATAPUMP_QUETAB_S SYS AQ$_KUPC$DATAPUMP_QUETAB_T SYS AQ$_MEM_MC SYS AQ$_MESSAGE_TYPES SYS AQ$_PENDING_MESSAGES SYS AQ$_PROPAGATION_STATUS SYS AQ$_PUBLISHER SYS AQ$_QUEUE_STATISTICS SYS AQ$_QUEUE_TABLE_AFFINITIES SYS AQ$_REPLAY_INFO SYS AQ$_SCHEDULER$_EVENT_QTAB_G OWNER TABLE_NAME
------------------------------
SYS AQ$_SCHEDULER$_EVENT_QTAB_H SYS AQ$_SCHEDULER$_EVENT_QTAB_I SYS AQ$_SCHEDULER$_EVENT_QTAB_S SYS AQ$_SCHEDULER$_EVENT_QTAB_T SYS AQ$_SCHEDULER$_JOBQTAB_G SYS AQ$_SCHEDULER$_JOBQTAB_H SYS AQ$_SCHEDULER$_JOBQTAB_I SYS AQ$_SCHEDULER$_JOBQTAB_S SYS AQ$_SCHEDULER$_JOBQTAB_T SYS AQ$_SCHEDULES SYS AQ$_SYS$SERVICE_METRICS_TAB_G OWNER TABLE_NAME
------------------------------
SYS AQ$_SYS$SERVICE_METRICS_TAB_H SYS AQ$_SYS$SERVICE_METRICS_TAB_I SYS AQ$_SYS$SERVICE_METRICS_TAB_S SYS AQ$_SYS$SERVICE_METRICS_TAB_T SYS AQ_EVENT_TABLE SYS AQ_SRVNTFN_TABLE SYS ARGUMENT$ SYS ASSOCIATION$ SYS ATEMPTAB$ SYS ATTRCOL$ SYS ATTRIBUTE$ OWNER TABLE_NAME
------------------------------
SYS ATTRIBUTE_TRANSFORMATIONS$ SYS AUD$ SYS AUDIT$ SYS AUDIT_ACTIONS SYS AUX_STATS$ SYS AW$ SYS AW_OBJ$ SYS AW_PROP$ SYS BOOTSTRAP$ SYS CACHE_STATS_0$ SYS CACHE_STATS_1$ OWNER TABLE_NAME
------------------------------
SYS CCOL$ SYS CDC_CHANGE_COLUMNS$ SYS CDC_CHANGE_SETS$ SYS CDC_CHANGE_SOURCES$ SYS CDC_CHANGE_TABLES$ SYS CDC_PROPAGATED_SETS$ SYS CDC_PROPAGATIONS$ SYS CDC_SUBSCRIBED_COLUMNS$ SYS CDC_SUBSCRIBED_TABLES$ SYS CDC_SUBSCRIBERS$ SYS CDC_SYSTEM$ OWNER TABLE_NAME
------------------------------
SYS CDEF$ SYS CLU$ SYS CLUSTER_DATABASES SYS CLUSTER_INSTANCES SYS CLUSTER_NODES SYS COL$ SYS COLLECTION$ SYS COLTYPE$ SYS COL_USAGE$ SYS COM$ SYS CON$ OWNER TABLE_NAME
------------------------------
SYS CONTEXT$ SYS DBMS_ALERT_INFO SYS DBMS_APPS_UPG_WORKING SYS DBMS_LOCK_ALLOCATED SYS DBMS_UPG_ACTION_QUEUE SYS DBMS_UPG_CAT_C0$ SYS DBMS_UPG_CAT_CS$ SYS DBMS_UPG_CAT_CT$ SYS DBMS_UPG_CHANGE$ SYS DBMS_UPG_CON_MAPPING SYS DBMS_UPG_DEBUG OWNER TABLE_NAME
------------------------------
SYS DBMS_UPG_INVALIDATE SYS DBMS_UPG_LOG$ SYS DBMS_UPG_OBJAUTH_C0$ SYS DBMS_UPG_OBJAUTH_CS$ SYS DBMS_UPG_OBJAUTH_CT$ SYS DBMS_UPG_OBJECT$ SYS DBMS_UPG_RLS_C0$ SYS DBMS_UPG_RLS_CS$ SYS DBMS_UPG_RLS_CT$ SYS DBMS_UPG_STATUS$ SYS DBMS_UPG_SYSAUTH_C0$ OWNER TABLE_NAME
------------------------------
SYS DBMS_UPG_SYSAUTH_CS$ SYS DBMS_UPG_SYSAUTH_CT$ SYS DEFROLE$ SYS DEFSUBPART$ SYS DEFSUBPARTLOB$ SYS DEPENDENCY$ SYS DIM$ SYS DIMATTR$ SYS DIMJOINKEY$ SYS DIMLEVEL$ SYS DIMLEVELKEY$ OWNER TABLE_NAME
------------------------------
SYS DIR$ SYS DIR$ALERT_HISTORY SYS DIR$DATABASE_ATTRIBUTES SYS DIR$ESCALATE_OPERATIONS SYS DIR$INSTANCE_ACTIONS SYS DIR$MIGRATE_OPERATIONS SYS DIR$NODE_ATTRIBUTES SYS DIR$QUIESCE_OPERATIONS SYS DIR$REASON_STRINGS SYS DIR$RESONATE_OPERATIONS SYS DIR$SERVICE_ATTRIBUTES OWNER TABLE_NAME
------------------------------
SYS DIR$SERVICE_OPERATIONS SYS DIR$VICTIM_POLICY SYS DUAL SYS DUC$ SYS ENC$ SYS EPG$_AUTH SYS ERROR$ SYS EXPACT$ SYS EXPDEPACT$ SYS EXPDEPOBJ$ SYS EXPIMP_TTS_CT$ OWNER TABLE_NAME
------------------------------
SYS EXPPKGACT$ SYS EXPPKGOBJ$ SYS EXTERNAL_LOCATION$ SYS EXTERNAL_TAB$ SYS FET$ SYS FGA$ SYS FGACOL$ SYS FGA_LOG$ SYS FGR$_FILE_GROUPS SYS FGR$_FILE_GROUP_EXPORT_INFO SYS FGR$_FILE_GROUP_FILES OWNER TABLE_NAME
------------------------------
SYS FGR$_FILE_GROUP_VERSIONS SYS FGR$_TABLESPACE_INFO SYS FGR$_TABLE_INFO SYS FILE$ SYS FIXED_OBJ$ SYS HIER$ SYS HIERLEVEL$ SYS HISTGRM$ SYS HIST_HEAD$ SYS HS$_BASE_CAPS SYS HS$_BASE_DD OWNER TABLE_NAME
------------------------------
SYS HS$_CLASS_CAPS SYS HS$_CLASS_DD SYS HS$_CLASS_INIT SYS HS$_FDS_CLASS SYS HS$_FDS_CLASS_DATE SYS HS$_FDS_INST SYS HS$_INST_CAPS SYS HS$_INST_DD SYS HS$_INST_INIT SYS ICOL$ SYS ICOLDEP$ OWNER TABLE_NAME
------------------------------
SYS IDL_CHAR$ SYS IDL_SB4$ SYS IDL_UB1$ SYS IDL_UB2$ SYS ID_GENS$ SYS IMPDP_STATS SYS INCEXP SYS INCFIL SYS INCVID SYS IND$ SYS INDARRAYTYPE$ OWNER TABLE_NAME
------------------------------
SYS INDCOMPART$ SYS INDOP$ SYS INDPART$ SYS INDPART_PARAM$ SYS INDSUBPART$ SYS INDTYPES$ SYS IND_ONLINE$ SYS IND_STATS$ SYS INVALIDATION_REGISTRY$ SYS JAVAOBJ$ SYS JAVASNM$ OWNER TABLE_NAME
------------------------------
SYS JIJOIN$ SYS JIREFRESHSQL$ SYS JOB$ SYS KOPM$ SYS KU$NOEXP_TAB SYS KUPC$DATAPUMP_QUETAB SYS KU_NOEXP_TAB SYS LIBRARY$ SYS LINK$ SYS LOB$ SYS LOBCOMPPART$ OWNER TABLE_NAME
------------------------------
SYS LOBFRAG$ SYS LOC$ SYS LOG$ SYS LOGMNRG_ATTRCOL$ SYS LOGMNRG_ATTRIBUTE$ SYS LOGMNRG_CCOL$ SYS LOGMNRG_CDEF$ SYS LOGMNRG_COL$ SYS LOGMNRG_COLTYPE$ SYS LOGMNRG_DICTIONARY$ SYS LOGMNRG_ICOL$ OWNER TABLE_NAME
------------------------------
SYS LOGMNRG_IND$ SYS LOGMNRG_INDCOMPART$ SYS LOGMNRG_INDPART$ SYS LOGMNRG_INDSUBPART$ SYS LOGMNRG_LOB$ SYS LOGMNRG_LOBFRAG$ SYS LOGMNRG_OBJ$ SYS LOGMNRG_SEED$ SYS LOGMNRG_TAB$ SYS LOGMNRG_TABCOMPART$ SYS LOGMNRG_TABPART$ OWNER TABLE_NAME
------------------------------
SYS LOGMNRG_TABSUBPART$ SYS LOGMNRG_TS$ SYS LOGMNRG_TYPE$ SYS LOGMNRG_USER$ SYS LOGMNRT_ATTRCOL$ SYS LOGMNRT_ATTRIBUTE$ SYS LOGMNRT_CCOL$ SYS LOGMNRT_CDEF$ SYS LOGMNRT_COL$ SYS LOGMNRT_COLTYPE$ SYS LOGMNRT_DICTIONARY$ OWNER TABLE_NAME
------------------------------
SYS LOGMNRT_ICOL$ SYS LOGMNRT_IND$ SYS LOGMNRT_INDCOMPART$ SYS LOGMNRT_INDPART$ SYS LOGMNRT_INDSUBPART$ SYS LOGMNRT_LOB$ SYS LOGMNRT_LOBFRAG$ SYS LOGMNRT_OBJ$ SYS LOGMNRT_SEED$ SYS LOGMNRT_TAB$ SYS LOGMNRT_TABCOMPART$ OWNER TABLE_NAME
------------------------------
SYS LOGMNRT_TABPART$ SYS LOGMNRT_TABSUBPART$ SYS LOGMNRT_TS$ SYS LOGMNRT_TYPE$ SYS LOGMNRT_USER$ SYS LOGMNR_BUILDLOG SYS LOGMNR_INTERESTING_COLS SYS MAP_COMPLIST$ SYS MAP_ELEMENT$ SYS MAP_EXTELEMENT$ SYS MAP_FILE$ OWNER TABLE_NAME
------------------------------
SYS MAP_FILE_EXTENT$ SYS MAP_OBJECT SYS MAP_SUBELEMENT$ SYS METAFILTER$ SYS METANAMETRANS$ SYS METAPATHMAP$ SYS METASCRIPT$ SYS METASCRIPTFILTER$ SYS METASTYLESHEET SYS METAVIEW$ SYS METAXSL$ OWNER TABLE_NAME
------------------------------
SYS METAXSLPARAM$ SYS METHOD$ SYS MIGRATE$ SYS MLOG$ SYS MLOG_REFCOL$ SYS MON_MODS$ SYS MON_MODS_ALL$ SYS NCOMP_DLL$ SYS NOEXP$ SYS NTAB$ SYS OBJ$ OWNER TABLE_NAME
------------------------------
SYS OBJAUTH$ SYS OBJECT_USAGE SYS OBJPRIV$ SYS ODCI_SECOBJ$ SYS ODCI_WARNINGS$ SYS OID$ SYS OPANCILLARY$ SYS OPARG$ SYS OPBINDING$ SYS OPERATOR$ SYS OPQTYPE$ OWNER TABLE_NAME
------------------------------
SYS OPTSTAT_HIST_CONTROL$ SYS PARAMETER$ SYS PARTCOL$ SYS PARTLOB$ SYS PARTOBJ$ SYS PENDING_SESSIONS$ SYS PENDING_SUB_SESSIONS$ SYS PENDING_TRANS$ SYS PLAN_TABLE$ SYS PROCEDURE$ SYS PROCEDUREC$ OWNER TABLE_NAME
------------------------------
SYS PROCEDUREINFO$ SYS PROCEDUREJAVA$ SYS PROCEDUREPLSQL$ SYS PROFILE$ SYS PROFNAME$ SYS PROPS$ SYS PROXY_DATA$ SYS PROXY_INFO$ SYS PROXY_ROLE_DATA$ SYS PROXY_ROLE_INFO$ SYS PS$ OWNER TABLE_NAME
------------------------------
SYS PSTUBTBL SYS RECENT_RESOURCE_INCARNATIONS$ SYS RECO_SCRIPT$ SYS RECO_SCRIPT_BLOCK$ SYS RECO_SCRIPT_ERROR$ SYS RECO_SCRIPT_PARAMS$ SYS RECYCLEBIN$ SYS REC_TAB$ SYS REC_VAR$ SYS REDEF$ SYS REDEF_DEP_ERROR$ OWNER TABLE_NAME
------------------------------
SYS REDEF_OBJECT$ SYS REFCON$ SYS REG$ SYS REGISTRY$ SYS REGISTRY$HISTORY SYS REGISTRY$LOG SYS REGISTRY$SCHEMAS SYS REG_SNAP$ SYS RESOURCE_CONSUMER_GROUP$ SYS RESOURCE_COST$ SYS RESOURCE_GROUP_MAPPING$ OWNER TABLE_NAME
------------------------------
SYS RESOURCE_MAP SYS RESOURCE_MAPPING_PRIORITY$ SYS RESOURCE_PLAN$ SYS RESOURCE_PLAN_DIRECTIVE$ SYS RESULT$ SYS RGCHILD$ SYS RGROUP$ SYS RLS$ SYS RLS_CTX$ SYS RLS_GRP$ SYS RLS_SC$ OWNER TABLE_NAME
------------------------------
SYS RULE$ SYS RULESET$ SYS RULE_EC$ SYS RULE_MAP$ SYS RULE_SET$ SYS RULE_SET_EE$ SYS RULE_SET_FOB$ SYS RULE_SET_IEUAC$ SYS RULE_SET_IOT$ SYS RULE_SET_NL$ SYS RULE_SET_PR$ OWNER TABLE_NAME
------------------------------
SYS RULE_SET_RDEP$ SYS RULE_SET_RE$ SYS RULE_SET_ROP$ SYS RULE_SET_ROR$ SYS RULE_SET_TE$ SYS RULE_SET_VE$ SYS SCHEDULER$_CHAIN SYS SCHEDULER$_CLASS SYS SCHEDULER$_EVENT_LOG SYS SCHEDULER$_EVENT_QTAB SYS SCHEDULER$_EVTQ_SUB OWNER TABLE_NAME
------------------------------
SYS SCHEDULER$_GLOBAL_ATTRIBUTE SYS SCHEDULER$_JOB SYS SCHEDULER$_JOBQTAB SYS SCHEDULER$_JOB_ARGUMENT SYS SCHEDULER$_JOB_RUN_DETAILS SYS SCHEDULER$_OLDOIDS SYS SCHEDULER$_PROGRAM SYS SCHEDULER$_PROGRAM_ARGUMENT SYS SCHEDULER$_SCHEDULE SYS SCHEDULER$_SRCQ_INFO SYS SCHEDULER$_SRCQ_MAP OWNER TABLE_NAME
------------------------------
SYS SCHEDULER$_STEP SYS SCHEDULER$_STEP_STATE SYS SCHEDULER$_WINDOW SYS SCHEDULER$_WINDOW_DETAILS SYS SCHEDULER$_WINDOW_GROUP SYS SCHEDULER$_WINGRP_MEMBER SYS SECOBJ$ SYS SEG$ SYS SEQ$ SYS SERVICE$ SYS SETTINGS$ OWNER TABLE_NAME
------------------------------
SYS SLOG$ SYS SMON_SCN_TIME SYS SNAP$ SYS SNAP_COLMAP$ SYS SNAP_LOADERTIME$ SYS SNAP_LOGDEP$ SYS SNAP_OBJCOL$ SYS SNAP_REFOP$ SYS SNAP_REFTIME$ SYS SNAP_SITE$ SYS SOURCE$ OWNER TABLE_NAME
------------------------------
SYS SQL$ SYS SQL$TEXT SYS SQLPROF$ SYS SQLPROF$ATTR SYS SQLPROF$DESC SYS SQL_VERSION$ SYS STATS_TARGET$ SYS STMT_AUDIT_OPTION_MAP SYS STREAMS$_APPLY_MILESTONE SYS STREAMS$_APPLY_PROCESS SYS STREAMS$_APPLY_PROGRESS OWNER TABLE_NAME
------------------------------
SYS STREAMS$_APPLY_SPILL_MESSAGES SYS STREAMS$_APPLY_SPILL_MSGS_PART SYS STREAMS$_APPLY_SPILL_TXN SYS STREAMS$_APPLY_SPILL_TXN_LIST SYS STREAMS$_CAPTURE_PROCESS SYS STREAMS$_DEF_PROC SYS STREAMS$_DEST_OBJS SYS STREAMS$_DEST_OBJ_COLS SYS STREAMS$_EXTRA_ATTRS SYS STREAMS$_INTERNAL_TRANSFORM SYS STREAMS$_KEY_COLUMNS OWNER TABLE_NAME
------------------------------
SYS STREAMS$_MESSAGE_CONSUMERS SYS STREAMS$_MESSAGE_RULES SYS STREAMS$_PREPARE_DDL SYS STREAMS$_PREPARE_OBJECT SYS STREAMS$_PRIVILEGED_USER SYS STREAMS$_PROCESS_PARAMS SYS STREAMS$_PROPAGATION_PROCESS SYS STREAMS$_RULES SYS SUBCOLTYPE$ SYS SUBPARTCOL$ SYS SUM$ OWNER TABLE_NAME
------------------------------
SYS SUMAGG$ SYS SUMDELTA$ SYS SUMDEP$ SYS SUMDETAIL$ SYS SUMINLINE$ SYS SUMJOIN$ SYS SUMKEY$ SYS SUMPARTLOG$ SYS SUMPRED$ SYS SUMQB$ SYS SUPEROBJ$ OWNER TABLE_NAME
------------------------------
SYS SYN$ SYS SYS$SERVICE_METRICS_TAB SYS SYSAUTH$ SYS SYSTEM_PRIVILEGE_MAP SYS SYS_IOT_OVER_10125 SYS SYS_IOT_OVER_4468 SYS SYS_IOT_OVER_4474 SYS SYS_IOT_OVER_4478 SYS SYS_IOT_OVER_5062 SYS SYS_IOT_OVER_5148 SYS SYS_IOT_OVER_7141 OWNER TABLE_NAME
------------------------------
SYS SYS_IOT_OVER_8638 SYS SYS_IOT_OVER_8748 SYS SYS_IOT_OVER_9641 SYS TAB$ SYS TABCOMPART$ SYS TABLE_PRIVILEGE_MAP SYS TABPART$ SYS TABSUBPART$ SYS TAB_STATS$ SYS TRANSFORMATIONS$ SYS TRIGGER$ OWNER TABLE_NAME
------------------------------
SYS TRIGGERCOL$ SYS TRIGGERJAVAC$ SYS TRIGGERJAVAF$ SYS TRIGGERJAVAM$ SYS TRIGGERJAVAS$ SYS TRUSTED_LIST$ SYS TS$ SYS TSM_DST$ SYS TSM_SRC$ SYS TSQ$ SYS TYPE$ OWNER TABLE_NAME
------------------------------
SYS TYPED_VIEW$ SYS TYPEHIERARCHY$ SYS TYPE_MISC$ SYS UET$ SYS UGROUP$ SYS UNDO$ SYS USER$ SYS USER_ASTATUS_MAP SYS USER_HISTORY$ SYS USTATS$ SYS UTL_RECOMP_COMPILED OWNER TABLE_NAME
------------------------------
SYS UTL_RECOMP_ERRORS SYS UTL_RECOMP_SORTED SYS VIEW$ SYS VIEWCON$ SYS VIEWTRCOL$ SYS VTABLE$ SYS WARNING_SETTINGS$ SYS WRH$_ACTIVE_SESSION_HISTORY SYS WRH$_ACTIVE_SESSION_HISTORY_BL SYS WRH$_BG_EVENT_SUMMARY SYS WRH$_BUFFERED_QUEUES OWNER TABLE_NAME
------------------------------
SYS WRH$_BUFFERED_SUBSCRIBERS SYS WRH$_BUFFER_POOL_STATISTICS SYS WRH$_COMP_IOSTAT SYS WRH$_CR_BLOCK_SERVER SYS WRH$_CURRENT_BLOCK_SERVER SYS WRH$_DATAFILE SYS WRH$_DB_CACHE_ADVICE SYS WRH$_DB_CACHE_ADVICE_BL SYS WRH$_DLM_MISC SYS WRH$_DLM_MISC_BL SYS WRH$_ENQUEUE_STAT OWNER TABLE_NAME
------------------------------
SYS WRH$_EVENT_NAME SYS WRH$_FILEMETRIC_HISTORY SYS WRH$_FILESTATXS SYS WRH$_FILESTATXS_BL SYS WRH$_INSTANCE_RECOVERY SYS WRH$_INST_CACHE_TRANSFER SYS WRH$_INST_CACHE_TRANSFER_BL SYS WRH$_JAVA_POOL_ADVICE SYS WRH$_LATCH SYS WRH$_LATCH_BL SYS WRH$_LATCH_CHILDREN OWNER TABLE_NAME
------------------------------
SYS WRH$_LATCH_CHILDREN_BL SYS WRH$_LATCH_MISSES_SUMMARY SYS WRH$_LATCH_MISSES_SUMMARY_BL SYS WRH$_LATCH_NAME SYS WRH$_LATCH_PARENT SYS WRH$_LATCH_PARENT_BL SYS WRH$_LIBRARYCACHE SYS WRH$_LOG SYS WRH$_METRIC_NAME SYS WRH$_MTTR_TARGET_ADVICE SYS WRH$_OPTIMIZER_ENV OWNER TABLE_NAME
------------------------------
SYS WRH$_OSSTAT SYS WRH$_OSSTAT_BL SYS WRH$_OSSTAT_NAME SYS WRH$_PARAMETER SYS WRH$_PARAMETER_BL SYS WRH$_PARAMETER_NAME SYS WRH$_PGASTAT SYS WRH$_PGA_TARGET_ADVICE SYS WRH$_PROCESS_MEMORY_SUMMARY SYS WRH$_RESOURCE_LIMIT SYS WRH$_ROWCACHE_SUMMARY OWNER TABLE_NAME
------------------------------
SYS WRH$_ROWCACHE_SUMMARY_BL SYS WRH$_RULE_SET SYS WRH$_SEG_STAT SYS WRH$_SEG_STAT_BL SYS WRH$_SEG_STAT_OBJ SYS WRH$_SERVICE_NAME SYS WRH$_SERVICE_STAT SYS WRH$_SERVICE_STAT_BL SYS WRH$_SERVICE_WAIT_CLASS SYS WRH$_SERVICE_WAIT_CLASS_BL SYS WRH$_SESSMETRIC_HISTORY OWNER TABLE_NAME
------------------------------
SYS WRH$_SESS_TIME_STATS SYS WRH$_SGA SYS WRH$_SGASTAT SYS WRH$_SGASTAT_BL SYS WRH$_SGA_TARGET_ADVICE SYS WRH$_SHARED_POOL_ADVICE SYS WRH$_SQLSTAT SYS WRH$_SQLSTAT_BL SYS WRH$_SQLTEXT SYS WRH$_SQL_BIND_METADATA SYS WRH$_SQL_PLAN OWNER TABLE_NAME
------------------------------
SYS WRH$_SQL_SUMMARY SYS WRH$_SQL_WORKAREA_HISTOGRAM SYS WRH$_STAT_NAME SYS WRH$_STREAMS_APPLY_SUM SYS WRH$_STREAMS_CAPTURE SYS WRH$_STREAMS_POOL_ADVICE SYS WRH$_SYSMETRIC_HISTORY SYS WRH$_SYSMETRIC_SUMMARY SYS WRH$_SYSSTAT SYS WRH$_SYSSTAT_BL SYS WRH$_SYSTEM_EVENT OWNER TABLE_NAME
------------------------------
SYS WRH$_SYSTEM_EVENT_BL SYS WRH$_SYS_TIME_MODEL SYS WRH$_SYS_TIME_MODEL_BL SYS WRH$_TABLESPACE_SPACE_USAGE SYS WRH$_TABLESPACE_STAT SYS WRH$_TABLESPACE_STAT_BL SYS WRH$_TEMPFILE SYS WRH$_TEMPSTATXS SYS WRH$_THREAD SYS WRH$_UNDOSTAT SYS WRH$_WAITCLASSMETRIC_HISTORY OWNER TABLE_NAME
------------------------------
SYS WRH$_WAITSTAT SYS WRH$_WAITSTAT_BL SYS WRI$_ADV_ACTIONS SYS WRI$_ADV_ASA_RECO_DATA SYS WRI$_ADV_DEFINITIONS SYS WRI$_ADV_DEF_PARAMETERS SYS WRI$_ADV_DIRECTIVES SYS WRI$_ADV_FINDINGS SYS WRI$_ADV_JOURNAL SYS WRI$_ADV_MESSAGE_GROUPS SYS WRI$_ADV_OBJECTS OWNER TABLE_NAME
------------------------------
SYS WRI$_ADV_PARAMETERS SYS WRI$_ADV_RATIONALE SYS WRI$_ADV_RECOMMENDATIONS SYS WRI$_ADV_REC_ACTIONS SYS WRI$_ADV_SQLA_FAKE_REG SYS WRI$_ADV_SQLA_MAP SYS WRI$_ADV_SQLA_STMTS SYS WRI$_ADV_SQLA_TMP SYS WRI$_ADV_SQLT_BINDS SYS WRI$_ADV_SQLT_PLANS SYS WRI$_ADV_SQLT_RTN_PLAN OWNER TABLE_NAME
------------------------------
SYS WRI$_ADV_SQLT_STATISTICS SYS WRI$_ADV_SQLW_COLVOL SYS WRI$_ADV_SQLW_STMTS SYS WRI$_ADV_SQLW_SUM SYS WRI$_ADV_SQLW_TABLES SYS WRI$_ADV_SQLW_TABVOL SYS WRI$_ADV_TASKS SYS WRI$_ADV_USAGE SYS WRI$_AGGREGATION_ENABLED SYS WRI$_ALERT_HISTORY SYS WRI$_ALERT_OUTSTANDING OWNER TABLE_NAME
------------------------------
SYS WRI$_ALERT_THRESHOLD SYS WRI$_ALERT_THRESHOLD_LOG SYS WRI$_DBU_CPU_USAGE SYS WRI$_DBU_CPU_USAGE_SAMPLE SYS WRI$_DBU_FEATURE_METADATA SYS WRI$_DBU_FEATURE_USAGE SYS WRI$_DBU_HIGH_WATER_MARK SYS WRI$_DBU_HWM_METADATA SYS WRI$_DBU_USAGE_SAMPLE SYS WRI$_OPTSTAT_AUX_HISTORY SYS WRI$_OPTSTAT_HISTGRM_HISTORY OWNER TABLE_NAME
------------------------------
SYS WRI$_OPTSTAT_HISTHEAD_HISTORY SYS WRI$_OPTSTAT_IND_HISTORY SYS WRI$_OPTSTAT_OPR SYS WRI$_OPTSTAT_TAB_HISTORY SYS WRI$_SCH_CONTROL SYS WRI$_SCH_VOTES SYS WRI$_SEGADV_CNTRLTAB SYS WRI$_SEGADV_OBJLIST SYS WRI$_SQLSET_BINDS SYS WRI$_SQLSET_DEFINITIONS SYS WRI$_SQLSET_MASK OWNER TABLE_NAME
------------------------------
SYS WRI$_SQLSET_PLANS SYS WRI$_SQLSET_PLANS_TOCAP SYS WRI$_SQLSET_PLAN_LINES SYS WRI$_SQLSET_REFERENCES SYS WRI$_SQLSET_STATEMENTS SYS WRI$_SQLSET_STATISTICS SYS WRI$_SQLSET_WORKSPACE SYS WRI$_TRACING_ENABLED SYS WRM$_BASELINE SYS WRM$_DATABASE_INSTANCE SYS WRM$_SNAPSHOT OWNER TABLE_NAME
------------------------------
SYS WRM$_SNAP_ERROR SYS WRM$_WR_CONTROL SYS XDB_INSTALLATION_TAB SYS _default_auditing_options_ SYSTEM AQ$_INTERNET_AGENTS SYSTEM AQ$_INTERNET_AGENT_PRIVS SYSTEM AQ$_QUEUES SYSTEM AQ$_QUEUE_TABLES SYSTEM AQ$_SCHEDULES SYSTEM DEF$_AQCALL SYSTEM DEF$_AQERROR OWNER TABLE_NAME
------------------------------
SYSTEM DEF$_CALLDEST SYSTEM DEF$_DEFAULTDEST SYSTEM DEF$_DESTINATION SYSTEM DEF$_ERROR SYSTEM DEF$_LOB SYSTEM DEF$_ORIGIN SYSTEM DEF$_PROPAGATOR SYSTEM DEF$_PUSHED_TRANSACTIONS SYSTEM DEF$_TEMP$LOB SYSTEM HELP SYSTEM LOGMNRC_DBNAME_UID_MAP OWNER TABLE_NAME
------------------------------
SYSTEM LOGMNRC_GSII SYSTEM LOGMNRC_GTCS SYSTEM LOGMNRC_GTLO SYSTEM LOGMNRP_CTAS_PART_MAP SYSTEM LOGMNRT_MDDL$ SYSTEM LOGMNR_AGE_SPILL$ SYSTEM LOGMNR_ATTRCOL$ SYSTEM LOGMNR_ATTRIBUTE$ SYSTEM LOGMNR_CCOL$ SYSTEM LOGMNR_CDEF$ SYSTEM LOGMNR_COL$ OWNER TABLE_NAME
------------------------------
SYSTEM LOGMNR_COLTYPE$ SYSTEM LOGMNR_DICTIONARY$ SYSTEM LOGMNR_DICTSTATE$ SYSTEM LOGMNR_ERROR$ SYSTEM LOGMNR_FILTER$ SYSTEM LOGMNR_HEADER1$ SYSTEM LOGMNR_HEADER2$ SYSTEM LOGMNR_ICOL$ SYSTEM LOGMNR_IND$ SYSTEM LOGMNR_INDCOMPART$ SYSTEM LOGMNR_INDPART$ OWNER TABLE_NAME
------------------------------
SYSTEM LOGMNR_INDSUBPART$ SYSTEM LOGMNR_LOB$ SYSTEM LOGMNR_LOBFRAG$ SYSTEM LOGMNR_LOG$ SYSTEM LOGMNR_OBJ$ SYSTEM LOGMNR_PARAMETER$ SYSTEM LOGMNR_PROCESSED_LOG$ SYSTEM LOGMNR_RESTART_CKPT$ SYSTEM LOGMNR_RESTART_CKPT_TXINFO$ SYSTEM LOGMNR_SESSION$ SYSTEM LOGMNR_SESSION_EVOLVE$ OWNER TABLE_NAME
------------------------------
SYSTEM LOGMNR_SPILL$ SYSTEM LOGMNR_TAB$ SYSTEM LOGMNR_TABCOMPART$ SYSTEM LOGMNR_TABPART$ SYSTEM LOGMNR_TABSUBPART$ SYSTEM LOGMNR_TS$ SYSTEM LOGMNR_TYPE$ SYSTEM LOGMNR_UID$ SYSTEM LOGMNR_USER$ SYSTEM LOGSTDBY$APPLY_MILESTONE SYSTEM LOGSTDBY$APPLY_PROGRESS OWNER TABLE_NAME
------------------------------
SYSTEM LOGSTDBY$EVENTS SYSTEM LOGSTDBY$HISTORY SYSTEM LOGSTDBY$PARAMETERS SYSTEM LOGSTDBY$PLSQL SYSTEM LOGSTDBY$SCN SYSTEM LOGSTDBY$SKIP SYSTEM LOGSTDBY$SKIP_SUPPORT SYSTEM LOGSTDBY$SKIP_TRANSACTION SYSTEM MVIEW$_ADV_AJG SYSTEM MVIEW$_ADV_BASETABLE SYSTEM MVIEW$_ADV_CLIQUE OWNER TABLE_NAME
------------------------------
SYSTEM MVIEW$_ADV_ELIGIBLE SYSTEM MVIEW$_ADV_EXCEPTIONS SYSTEM MVIEW$_ADV_FILTER SYSTEM MVIEW$_ADV_FILTERINSTANCE SYSTEM MVIEW$_ADV_FJG SYSTEM MVIEW$_ADV_GC SYSTEM MVIEW$_ADV_INFO SYSTEM MVIEW$_ADV_JOURNAL SYSTEM MVIEW$_ADV_LEVEL SYSTEM MVIEW$_ADV_LOG SYSTEM MVIEW$_ADV_OUTPUT OWNER TABLE_NAME
------------------------------
SYSTEM MVIEW$_ADV_PARAMETERS SYSTEM MVIEW$_ADV_PLAN SYSTEM MVIEW$_ADV_PRETTY SYSTEM MVIEW$_ADV_ROLLUP SYSTEM MVIEW$_ADV_SQLDEPEND SYSTEM MVIEW$_ADV_TEMP SYSTEM MVIEW$_ADV_WORKLOAD SYSTEM OL$ SYSTEM OL$HINTS SYSTEM OL$NODES SYSTEM REPCAT$_AUDIT_ATTRIBUTE OWNER TABLE_NAME
------------------------------
SYSTEM REPCAT$_AUDIT_COLUMN SYSTEM REPCAT$_COLUMN_GROUP SYSTEM REPCAT$_CONFLICT SYSTEM REPCAT$_DDL SYSTEM REPCAT$_EXCEPTIONS SYSTEM REPCAT$_EXTENSION SYSTEM REPCAT$_FLAVORS SYSTEM REPCAT$_FLAVOR_OBJECTS SYSTEM REPCAT$_GENERATED SYSTEM REPCAT$_GROUPED_COLUMN SYSTEM REPCAT$_INSTANTIATION_DDL OWNER TABLE_NAME
------------------------------
SYSTEM REPCAT$_KEY_COLUMNS SYSTEM REPCAT$_OBJECT_PARMS SYSTEM REPCAT$_OBJECT_TYPES SYSTEM REPCAT$_PARAMETER_COLUMN SYSTEM REPCAT$_PRIORITY SYSTEM REPCAT$_PRIORITY_GROUP SYSTEM REPCAT$_REFRESH_TEMPLATES SYSTEM REPCAT$_REPCAT SYSTEM REPCAT$_REPCATLOG SYSTEM REPCAT$_REPCOLUMN SYSTEM REPCAT$_REPGROUP_PRIVS OWNER TABLE_NAME
------------------------------
SYSTEM REPCAT$_REPOBJECT SYSTEM REPCAT$_REPPROP SYSTEM REPCAT$_REPSCHEMA SYSTEM REPCAT$_RESOLUTION SYSTEM REPCAT$_RESOLUTION_METHOD SYSTEM REPCAT$_RESOLUTION_STATISTICS SYSTEM REPCAT$_RESOL_STATS_CONTROL SYSTEM REPCAT$_RUNTIME_PARMS SYSTEM REPCAT$_SITES_NEW SYSTEM REPCAT$_SITE_OBJECTS SYSTEM REPCAT$_SNAPGROUP OWNER TABLE_NAME
------------------------------
SYSTEM REPCAT$_TEMPLATE_OBJECTS SYSTEM REPCAT$_TEMPLATE_PARMS SYSTEM REPCAT$_TEMPLATE_REFGROUPS SYSTEM REPCAT$_TEMPLATE_SITES SYSTEM REPCAT$_TEMPLATE_STATUS SYSTEM REPCAT$_TEMPLATE_TARGETS SYSTEM REPCAT$_TEMPLATE_TYPES SYSTEM REPCAT$_USER_AUTHORIZATIONS SYSTEM REPCAT$_USER_PARM_VALUES SYSTEM SQLPLUS_PRODUCT_PROFILE TSMSYS SRS$ OWNER TABLE_NAME
------------------------------
XDB MIGR9202STATUS XDB XDB$CHECKOUTS XDB XDB$COLUMN_INFO XDB XDB$DXPATH XDB XDB$DXPTAB XDB XDB$H_INDEX XDB XDB$NMSPC_ID XDB XDB$PATH_ID XDB XDB$PATH_INDEX_PARAMS XDB XDB$QNAME_ID XDB XDB$ROOT_INFO 1089 rows selected. SQL> SQL> SQL>
</source>
Query all_tables for owner and table_name
<source lang="sql">
SQL> SQL> SQL> select owner, table_name
2 from all_tables where rownum < 50 3 order by owner, table_name;
OWNER TABLE_NAME
------------------------------
SYS ARGUMENT$ SYS ATTRCOL$ SYS BOOTSTRAP$ SYS CCOL$ SYS CDEF$ SYS CLU$ SYS COL$ SYS COLTYPE$ SYS CON$ SYS DIR$ SYS ERROR$ OWNER TABLE_NAME
------------------------------
SYS FET$ SYS FILE$ SYS ICOL$ SYS ICOLDEP$ SYS IDL_CHAR$ SYS IDL_SB4$ SYS IDL_UB1$ SYS IDL_UB2$ SYS IND$ SYS JAVAOBJ$ SYS LIBRARY$ OWNER TABLE_NAME
------------------------------
SYS LOB$ SYS NTAB$ SYS OBJ$ SYS OBJAUTH$ SYS OPQTYPE$ SYS PROCEDURE$ SYS PROCEDUREINFO$ SYS PROXY_DATA$ SYS PROXY_ROLE_DATA$ SYS REFCON$ SYS SEG$ OWNER TABLE_NAME
------------------------------
SYS SEQ$ SYS SOURCE$ SYS SUBCOLTYPE$ SYS SUPEROBJ$ SYS SYN$ SYS TAB$ SYS TS$ SYS TSQ$ SYS TYPED_VIEW$ SYS TYPE_MISC$ SYS UET$ OWNER TABLE_NAME
------------------------------
SYS UGROUP$ SYS UNDO$ SYS USER$ SYS VIEW$ SYS VIEWTRCOL$ 49 rows selected. SQL>
</source>
