Oracle PL/SQL/System Tables Views/ALL TABLES — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
| |
Версия 13:45, 26 мая 2010
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>