Oracle PL/SQL/System Tables Views/ALL TABLES

Материал из SQL эксперт
Перейти к: навигация, поиск

Get all tables that you have been granted access to

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>



Query all_tables for owner and table_name

 
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>