Get all tables that you have been granted access to : ALL_TABLES « System Tables Views « Oracle PL / SQL

Oracle PL / SQL
1. Aggregate Functions
2. Analytical Functions
3. Char Functions
4. Constraints
5. Conversion Functions
6. Cursor
7. Data Type
8. Date Timezone
9. Hierarchical Query
10. Index
11. Insert Delete Update
12. Large Objects
13. Numeric Math Functions
14. Object Oriented Database
15. PL SQL
16. Regular Expressions
17. Report Column Page
18. Result Set
19. Select Query
20. Sequence
21. SQL Plus
22. Stored Procedure Function
23. Subquery
24. System Packages
25. System Tables Views
26. Table
27. Table Joins
28. Trigger
29. User Previliege
30. View
31. XML
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Oracle PL / SQL » System Tables Views » ALL_TABLES 
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>

           
       
Related examples in the same category
1. Query all_tables for owner and table_name
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.