SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'USER_%' ORDER BY TABLE_NAME;
TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
USER_ADVISOR_ACTIONS
USER_ADVISOR_DIRECTIVES
USER_ADVISOR_FINDINGS
USER_ADVISOR_JOURNAL
USER_ADVISOR_LOG
USER_ADVISOR_OBJECTS
USER_ADVISOR_PARAMETERS
USER_ADVISOR_RATIONALE
USER_ADVISOR_RECOMMENDATIONS
USER_ADVISOR_SQLA_REC_SUM
USER_ADVISOR_SQLA_WK_MAP
USER_ADVISOR_SQLA_WK_STMTS
USER_ADVISOR_SQLW_COLVOL
USER_ADVISOR_SQLW_JOURNAL
USER_ADVISOR_SQLW_PARAMETERS
USER_ADVISOR_SQLW_STMTS
USER_ADVISOR_SQLW_SUM
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLW_TABVOL
USER_ADVISOR_SQLW_TEMPLATES
USER_ADVISOR_TASKS
USER_ADVISOR_TEMPLATES
USER_ALL_TABLES - Description of all object and relational tables owned by the user's
USER_AQ_AGENT_PRIVS -
USER_ARGUMENTS - Arguments in object accessible to the user
USER_ASSOCIATIONS - All assocations defined by the user
USER_ATTRIBUTE_TRANSFORMATIONS -
USER_AUDIT_OBJECT - Audit trail records for statements concerning objects, specifically: table, cluster, view, index, se
- quence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace,
- role, user
USER_AUDIT_POLICIES - All fine grained auditing policies for objects in user schema
USER_AUDIT_POLICY_COLUMNS - Users fine grained auditing policy columns in the database
USER_AUDIT_SESSION - All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT - Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER_AUDIT_TRAIL - Audit trail entries relevant to the user
USER_AWS - Analytic Workspaces owned by the user
USER_AW_OBJ - Objects in Analytic Workspaces owned by the user
USER_AW_PROP - Object properties in Analytic Workspaces owned by the user
USER_AW_PS - Pagespaces in Analytic Workspaces owned by the user
USER_BASE_TABLE_MVIEWS - All materialized views with log(s) owned by the user in the database
USER_CATALOG - Tables, Views, Synonyms and Sequences owned by the user
USER_CHANGE_NOTIFICATION_REGS - change notification registrations for current user
USER_CLUSTERS - Descriptions of user's own clusters
USER_CLUSTER_HASH_EXPRESSIONS - Hash functions for the user's hash clusters
USER_CLU_COLUMNS - Mapping of table columns to cluster columns
USER_COLL_TYPES - Description of the user's own named collection types
USER_COL_COMMENTS - Comments on columns of user's tables and views
USER_COL_PRIVS - Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE - All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD - Grants on columns for which the user is the grantee
USER_CONSTRAINTS - Constraint definitions on user's own tables
USER_CONS_COLUMNS - Information about accessible columns in constraint definitions
USER_CONS_OBJ_COLUMNS - List of types an object column or attribute is constrained to in the tables owned by the user
USER_DATAPUMP_JOBS - Datapump jobs for current user
USER_DB_LINKS - Database links owned by the user
USER_DEPENDENCIES - Dependencies to and from a users objects
USER_DIMENSIONS - Description of the dimension objects accessible to the DBA
USER_DIM_ATTRIBUTES - Representation of the relationship between a dimension level and a functionally dependent column
USER_DIM_CHILD_OF - Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
USER_DIM_HIERARCHIES - Representation of a dimension hierarchy
USER_DIM_JOIN_KEY - Representation of a join between two dimension tables.
USER_DIM_LEVELS - Description of dimension levels visible to DBA
USER_DIM_LEVEL_KEY - Representations of columns of a dimension level
USER_ENCRYPTED_COLUMNS - Encryption information on columns of tables owned by the user
USER_EPG_DAD_AUTHORIZATION - DADs authorized to use the user's privileges
USER_ERRORS - Current errors on stored objects owned by the user
USER_EVALUATION_CONTEXTS - rule evaluation contexts owned by user
USER_EVALUATION_CONTEXT_TABLES - tables in user rule evaluation contexts
USER_EVALUATION_CONTEXT_VARS - variables in user rule evaluation contexts
USER_EXTENTS - Extents comprising segments owned by the user
USER_EXTERNAL_LOCATIONS - Description of the user's external tables locations
USER_EXTERNAL_TABLES - Description of the user's own external tables
USER_FILE_GROUPS - Details about file groups
USER_FILE_GROUP_EXPORT_INFO - Details about export information of file group versions
USER_FILE_GROUP_FILES - Details about file group files
USER_FILE_GROUP_TABLES - Details about the tables in the file group repository
USER_FILE_GROUP_TABLESPACES - Details about the transportable tablespaces in the file group repository
USER_FILE_GROUP_VERSIONS - Details about file group versions
USER_FREE_SPACE - Free extents in tablespaces accessible to the user
USER_HISTOGRAMS - Synonym for USER_TAB_HISTOGRAMS
USER_INDEXES - Description of the user's own indexes
USER_INDEXTYPES - All user indextypes
USER_INDEXTYPE_ARRAYTYPES - All array types specified by the indextype
USER_INDEXTYPE_COMMENTS - Comments for user-defined indextypes
USER_INDEXTYPE_OPERATORS - All user indextype operators
USER_IND_COLUMNS - COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
USER_IND_EXPRESSIONS - Functional index expressions in user's indexes and indexes on user's tables
USER_IND_PARTITIONS -
USER_IND_STATISTICS - Optimizer statistics for user's own indexes
USER_IND_SUBPARTITIONS -
USER_INTERNAL_TRIGGERS - Description of the internal triggers on the user's own tables
USER_JAVA_ARGUMENTS - argument information of stored java class owned by the user
USER_JAVA_CLASSES - class level information of stored java class owned by the user
USER_JAVA_DERIVATIONS - this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user
USER_JAVA_FIELDS - field information of stored java class owned by the user
USER_JAVA_IMPLEMENTS - interfaces implemented by the stored java class owned by user
USER_JAVA_INNERS - list of inner classes refered by the stored java class owned by user
USER_JAVA_LAYOUTS - class layout information about stored java class owned by the user
USER_JAVA_METHODS - method information of stored java class owned by the user
USER_JAVA_NCOMPS - ncomp related information of java classes owned by user
USER_JAVA_POLICY - java security Permissions for current user
USER_JAVA_RESOLVERS - resolver of java class owned by user
USER_JAVA_THROWS - list of exceptions thrown from a method of a class owned by user
USER_JOBS - All jobs owned by this user
USER_JOIN_IND_COLUMNS - Join Index columns comprising the join conditions
USER_LIBRARIES - Description of the user's own libraries
USER_LOBS - Description of the user's own LOBs contained in the user's own tables
USER_LOB_PARTITIONS -
USER_LOB_SUBPARTITIONS -
USER_LOB_TEMPLATES -
USER_LOG_GROUPS - Log group definitions on user's own tables
USER_LOG_GROUP_COLUMNS - Information about columns in log group definitions
USER_METHOD_PARAMS - Description of method parameters of the user's own types
USER_METHOD_RESULTS - Description of method results of the user's own types
USER_MVIEWS - All materialized views in the database
USER_MVIEW_AGGREGATES - Description of the materialized view aggregates created by the user
USER_MVIEW_ANALYSIS - Description of the materialized views created by the user
USER_MVIEW_COMMENTS - Comments on materialized views owned by the user
USER_MVIEW_DETAIL_RELATIONS - Description of the materialized view detail tables of the materialized views created by the user
USER_MVIEW_JOINS - Description of a join between two columns in the WHERE clause of a materialized view created by the user
USER_MVIEW_KEYS - Description of the columns that appear in the GROUP BY list of a materialized view created by the user
USER_MVIEW_LOGS - All materialized view logs owned by the user
USER_MVIEW_REFRESH_TIMES - Materialized views and their last refresh times for each master table that the user can look at
USER_NESTED_TABLES - Description of nested tables contained in the user's own tables
USER_NESTED_TABLE_COLS - Columns of nested tables
USER_OBJECTS - Objects owned by the user
USER_OBJECT_SIZE - Sizes, in bytes, of various pl/sql objects
USER_OBJECT_TABLES - Description of the user's own object tables
USER_OBJ_AUDIT_OPTS - Auditing options for user's own tables and views with atleast one option set
USER_OBJ_COLATTRS - Description of object columns and attributes contained in tables owned by the user
USER_OPANCILLARY - All ancillary opertors defined by user
USER_OPARGUMENTS - All operator arguments of operators defined by user
USER_OPBINDINGS - All binding functions or methods on operators defined by the user
USER_OPERATORS - All user operators
USER_OPERATOR_COMMENTS - Comments for user-defined operators
USER_OUTLINES - Stored outlines owned by the user
USER_OUTLINE_HINTS - Hints stored in outlines owned by the user
USER_PARTIAL_DROP_TABS - User tables with unused columns
USER_PART_COL_STATISTICS -
USER_PART_HISTOGRAMS -
USER_PART_INDEXES -
USER_PART_KEY_COLUMNS -
USER_PART_LOBS -
USER_PART_TABLES -
USER_PASSWORD_LIMITS - Display password limits of the user
USER_PENDING_CONV_TABLES - All user's tables which are not upgraded to the latest type version
USER_PLSQL_OBJECT_SETTINGS - Compiler settings of stored objects owned by the user
USER_POLICIES - All row level security policies for synonyms, tables, or views owned by the user
USER_POLICY_CONTEXTS - All policy driving context defined for synonyms, tables, or views in current schema
USER_POLICY_GROUPS - All policy groups defined for any synonym, table, or view
USER_PROCEDURES - Description of the users own procedures
USER_PROXIES - Description of connections the user is allowed to proxy
USER_PUBLISHED_COLUMNS - Source columns available for Change Data Capture
USER_QUEUES - All queues owned by the user
USER_QUEUE_PUBLISHERS -
USER_QUEUE_SCHEDULES -
USER_QUEUE_SUBSCRIBERS - queue subscribers under a user'schema
USER_QUEUE_TABLES - All queue tables created by the user
USER_RECYCLEBIN - User view of his recyclebin
USER_REFRESH - All the refresh groups
USER_REFRESH_CHILDREN - All the objects in refresh groups, where the user owns the refresh group
USER_REFS - Description of the user's own REF columns contained in the user's own tables
USER_REGISTERED_MVIEWS - Remote materialized views of local tables currently using logs owned by the user
USER_REGISTERED_SNAPSHOTS - Remote snapshots of local tables currently using logs owned by the user
USER_REGISTRY -
USER_REPAUDIT_ATTRIBUTE - Information about attributes automatically maintained for replication
USER_REPAUDIT_COLUMN - Information about columns in all shadow tables for user's replicated tables
USER_REPCAT -
USER_REPCATLOG - Information about the current user's asynchronous administration requests
USER_REPCOLUMN - Replicated columns for the current user's table in ascending order
USER_REPCOLUMN_GROUP - All column groups of user's replicated tables
USER_REPCONFLICT -
USER_REPDDL - Arguments that do not fit in a single repcat log record
USER_REPFLAVORS - Flavors current user created for replicated object groups
USER_REPFLAVOR_COLUMNS - Replicated columns from current user's tables in flavors
USER_REPFLAVOR_OBJECTS - Replicated user objects in flavors
USER_REPGENERATED - Objects generated for the current user to support replication
USER_REPGENOBJECTS - Objects generated for the current user to support replication
USER_REPGROUP - Replication information about the current user
USER_REPGROUPED_COLUMN - Columns in the all column groups of user's replicated tables
USER_REPGROUP_PRIVILEGES - Information about users who are registered for object group privileges
USER_REPKEY_COLUMNS - Primary columns for a table using column-level replication
USER_REPOBJECT - Replication information about the current user's objects
USER_REPPARAMETER_COLUMN - All columns used for resolving conflicts in user's replicated tables
USER_REPPRIORITY - Values and their corresponding priorities in user's priority groups
USER_REPPRIORITY_GROUP - Information about user's priority groups
USER_REPPROP - Propagation information about the current user's objects
USER_REPRESOLUTION - Description of all conflict resolutions for user's replicated tables
USER_REPRESOLUTION_METHOD - All conflict resolution methods accessible to the user
USER_REPRESOLUTION_STATISTICS - Statistics for conflict resolutions for user's replicated tables
USER_REPRESOL_STATS_CONTROL - Information about statistics collection for conflict resolutions for user's replicated tables
USER_REPSCHEMA - N-way replication information about the current user
USER_REPSITES - N-way replication information about the current user
USER_RESOURCE_LIMITS - Display resource limit of the user
USER_RESUMABLE - Resumable session information for current user
USER_REWRITE_EQUIVALENCES - Description of all rewrite equivalence owned by the user
USER_ROLE_PRIVS - Roles granted to current user
USER_RSRC_CONSUMER_GROUP_PRIVS - Switch privileges for consumer groups for the user
USER_RSRC_MANAGER_SYSTEM_PRIVS - system privileges for the resource manager for the user
USER_RULES - Rules owned by the user
USER_RULESETS - Rulesets owned by the user: maintained for backward compatibility
USER_RULE_SETS - Rule sets owned by the user
USER_RULE_SET_RULES - Rules in user rule sets
USER_SCHEDULER_CHAINS - All scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_RULES - All rules from scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_STEPS - All steps of scheduler chains owned by the current user
USER_SCHEDULER_JOBS - All scheduler jobs in the database
USER_SCHEDULER_JOB_ARGS - All arguments with set values of all scheduler jobs in the database
USER_SCHEDULER_JOB_LOG - Logged information for all scheduler jobs
USER_SCHEDULER_JOB_RUN_DETAILS - The details of a job run
USER_SCHEDULER_PROGRAMS - Scheduler programs owned by the current user
USER_SCHEDULER_PROGRAM_ARGS - All arguments of all scheduler programs in the database
USER_SCHEDULER_RUNNING_CHAINS - All steps of chains being run by jobs owned by the current user
USER_SCHEDULER_SCHEDULES - Schedules belonging to the current user
USER_SECONDARY_OBJECTS - All secondary objects for domain indexes
USER_SEC_RELEVANT_COLS - Security Relevant columns of VPD policies for tables or views owned by the user
USER_SEGMENTS - Storage allocated for all database segments
USER_SEQUENCES - Description of the user's own SEQUENCEs
USER_SNAPSHOTS - Snapshots the user can look at
USER_SNAPSHOT_LOGS - All snapshot logs owned by the user
USER_SNAPSHOT_REFRESH_TIMES - Synonym for USER_MVIEW_REFRESH_TIMES
USER_SOURCE - Source of stored objects accessible to the user
USER_SOURCE_TABLES - Source tables available for Change Data Capture
USER_SQLJ_TYPES - Description of the user's own types
USER_SQLJ_TYPE_ATTRS - Description of attributes of the user's own types
USER_SQLJ_TYPE_METHODS - Description of methods of the user's own types
USER_SQLSET -
USER_SQLSET_BINDS -
USER_SQLSET_DEFINITIONS - Synonym for USER_SQLSET
USER_SQLSET_PLANS -
USER_SQLSET_REFERENCES -
USER_SQLSET_STATEMENTS -
USER_SQLTUNE_BINDS -
USER_SQLTUNE_PLANS -
USER_SQLTUNE_RATIONALE_PLAN -
USER_SQLTUNE_STATISTICS -
USER_STORED_SETTINGS - Parameter settings for objects owned by the user
USER_SUBPARTITION_TEMPLATES -
USER_SUBPART_COL_STATISTICS -
USER_SUBPART_HISTOGRAMS -
USER_SUBPART_KEY_COLUMNS -
USER_SUBSCRIBED_COLUMNS - Change Data Capture subscribed columns
USER_SUBSCRIBED_TABLES - Change Data Capture subscribed tables
USER_SUBSCRIPTIONS - Change Data Capture subscriptions
USER_SUMMARIES - Description of the summaries created by the user
USER_SYNONYMS - The user's private synonyms
USER_SYS_PRIVS - System privileges granted to current user
USER_TABLES - Description of the user's own relational tables
USER_TABLESPACES - Description of accessible tablespaces
USER_TAB_COLS - Columns of user's tables, views and clusters
USER_TAB_COLUMNS - Columns of user's tables, views and clusters
USER_TAB_COL_STATISTICS - Columns of user's tables, views and clusters
USER_TAB_COMMENTS - Comments on the tables and views owned by the user
USER_TAB_HISTOGRAMS - Histograms on columns of user's tables
USER_TAB_MODIFICATIONS - Information regarding modifications to tables
USER_TAB_PARTITIONS -
USER_TAB_PRIVS - Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE - All grants on objects owned by the user
USER_TAB_PRIVS_RECD - Grants on objects for which the user is the grantee
USER_TAB_STATISTICS - Optimizer statistics of the user's own tables
USER_TAB_STATS_HISTORY - History of table statistics modifications
USER_TAB_SUBPARTITIONS -
USER_TRANSFORMATIONS -
USER_TRIGGERS - Triggers owned by the user
USER_TRIGGER_COLS - Column usage in user's triggers
USER_TS -
USER_TS_QUOTAS - Tablespace quotas for the user
USER_TUNE_MVIEW - tune_mview catalog view owned by the user
USER_TYPES - Description of the user's own types
USER_TYPE_ATTRS - Description of attributes of the user's own types
USER_TYPE_METHODS - Description of methods of the user's own types
USER_TYPE_VERSIONS - Description of each version of the user's types
USER_UNUSED_COL_TABS - User tables with unused columns
USER_UPDATABLE_COLUMNS - Description of updatable columns
USER_USERS - Information about the current user
USER_USTATS - All statistics on tables or indexes owned by the user
USER_VARRAYS - Description of varrays contained in the user's own tables
USER_VIEWS - Description of the user's own views
USER_WARNING_SETTINGS - Warning Parameter settings for objects owned by the user
USER_WORKSPACES -
USER_XML_COLUMN_NAMES -
USER_XML_INDEXES - Description of the user's own XMLType indexes
USER_XML_SCHEMAS - Description of XML Schemas registered by the user
USER_XML_TABLES - Description of the user's own XMLType tables
USER_XML_TAB_COLS - Description of the user's own XMLType tables
USER_XML_VIEWS - Description of the user's own XMLType views
USER_XML_VIEW_COLS - Description of the user's own XMLType views
285 rows selected.
SQL> SPOOL OFF;
