Thursday, January 3, 2008

Oracle Dictionary - All Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'ALL_%' ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
ALL_ALL_TABLES - Description of all object and relational tables accessible to the user
ALL_APPLY - Details about each apply process that dequeues from the queue visible to the current user
ALL_APPLY_CONFLICT_COLUMNS - Details about conflict resolution on tables visible to the current user
ALL_APPLY_DML_HANDLERS - Details about the dml handler on tables visible to the current user
ALL_APPLY_ENQUEUE - Details about the apply enqueue action for user accessible rules where the destination queue exists
- and is visible to the user
ALL_APPLY_ERROR - Error transactions that were generated after dequeuing from the queue visible to the current user
ALL_APPLY_EXECUTE - Details about the apply execute action for all rules visible to the user
ALL_APPLY_KEY_COLUMNS - Alternative key columns for a STREAMS table visible to the current user
ALL_APPLY_PARAMETERS - Details about parameters of each apply process that dequeues from the queue visible to the current user
ALL_APPLY_PROGRESS - Information about the progress made by the apply process that dequeues from the queue visible to the current user
ALL_APPLY_TABLE_COLUMNS - Details about the columns of destination table object visible to the user
ALL_ARGUMENTS - Arguments in object accessible to the user
ALL_ASSOCIATIONS - All associations available to the user
ALL_AUDIT_POLICIES - All fine grained auditing policies in the database
ALL_AUDIT_POLICY_COLUMNS - All fine grained auditing policy columns in the database
ALL_AWS - Analytic Workspaces accessible to the user
ALL_AW_AC - Active Catalog Analytic Workspaces accessible to the user
ALL_AW_AC_10G -
ALL_AW_OBJ - Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP - Object properties in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME - Analytic Workspace property names accessible to the user
ALL_AW_PS - Pagespaces in Analytic Workspaces accessible to the user
ALL_BASE_TABLE_MVIEWS - All materialized views with log(s) in the database that the user can see
ALL_CAPTURE - Details about each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_EXTRA_ATTRIBUTES - Extra attributes for a capture process that is visible to the current user
ALL_CAPTURE_PARAMETERS - Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_PREPARED_DATABASE - Is the local database prepared for instantiation?
ALL_CAPTURE_PREPARED_SCHEMAS - All user schemas at the local database that are prepared for instantiation
ALL_CAPTURE_PREPARED_TABLES - All tables visible to the current user that are prepared for instantiation
ALL_CATALOG - All tables, views, synonyms, sequences accessible to the user
ALL_CLUSTERS - Description of clusters accessible to the user
ALL_CLUSTER_HASH_EXPRESSIONS - Hash functions for all accessible clusters
ALL_COLL_TYPES - Description of named collection types accessible to the user
ALL_COL_COMMENTS - Comments on columns of accessible tables and views
ALL_COL_PRIVS - Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_COL_PRIVS_MADE - Grants on columns for which the user is owner or grantor
ALL_COL_PRIVS_RECD - Grants on columns for which the user, PUBLIC or enabled role is the grantee
ALL_CONSTRAINTS - Constraint definitions on accessible tables
ALL_CONS_COLUMNS - Information about accessible columns in constraint definitions
ALL_CONS_OBJ_COLUMNS - List of types an object column or attribute is constrained to in the tables accessible to the user
ALL_CONTEXT - Description of all active context namespaces under the current session
ALL_DB_LINKS - Database links accessible to the user
ALL_DEF_AUDIT_OPTS - Auditing options for newly created objects
ALL_DEPENDENCIES - Dependencies to and from objects accessible to the user
ALL_DEQUEUE_QUEUES - All queues accessible to the user
ALL_DIMENSIONS - Description of the dimension objects accessible to the DBA
ALL_DIM_ATTRIBUTES - Representation of the relationship between a dimension level and a functionally dependent column
ALL_DIM_CHILD_OF - Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
ALL_DIM_HIERARCHIES - Representation of a dimension hierarchy
ALL_DIM_JOIN_KEY - Representation of a join between two dimension tables.
ALL_DIM_LEVELS - Description of dimension levels visible to DBA
ALL_DIM_LEVEL_KEY - Representations of columns of a dimension level
ALL_DIRECTORIES - Description of all directories accessible to the user
ALL_ENCRYPTED_COLUMNS - Encryption information on all accessible columns
ALL_ERRORS - Current errors on stored objects that user is allowed to create
ALL_EVALUATION_CONTEXTS - rule evaluation contexts seen by user
ALL_EVALUATION_CONTEXT_TABLES - tables in all rule evaluation contexts seen by the user
ALL_EVALUATION_CONTEXT_VARS - variables in all rule evaluation contexts seen by the user
ALL_EXTERNAL_LOCATIONS - Description of the external tables locations accessible to the user
ALL_EXTERNAL_TABLES - Description of the external tables accessible to the user
ALL_FILE_GROUPS - Details about file groups
ALL_FILE_GROUP_EXPORT_INFO - Details about export information of file group versions
ALL_FILE_GROUP_FILES - Details about file group files
ALL_FILE_GROUP_TABLES - Details about the tables in the file group repository
ALL_FILE_GROUP_TABLESPACES - Details about the transportable tablespaces in the file group repository
ALL_FILE_GROUP_VERSIONS - Details about file group versions
ALL_HISTOGRAMS - Synonym for ALL_TAB_HISTOGRAMS
ALL_INDEXES - Descriptions of indexes on tables accessible to the user
ALL_INDEXTYPES - All indextypes available to the user
ALL_INDEXTYPE_ARRAYTYPES - All array types specified by the indextype
ALL_INDEXTYPE_COMMENTS - Comments for user-defined indextypes
ALL_INDEXTYPE_OPERATORS - All operators available to the user
ALL_IND_COLUMNS - COLUMNs comprising INDEXes on accessible TABLES
ALL_IND_EXPRESSIONS - FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
ALL_IND_PARTITIONS -
ALL_IND_STATISTICS - Optimizer statistics for all indexes on tables accessible to the user
ALL_IND_SUBPARTITIONS -
ALL_INTERNAL_TRIGGERS - Description of the internal triggers on the tables accessible to the user
ALL_JAVA_ARGUMENTS - argument information of stored java class accessible to the user
ALL_JAVA_CLASSES - class level information of stored java class accessible to the user
ALL_JAVA_DERIVATIONS - this view maps java source objects and their derived java class objects and java resource objects f
- or the java class accessible to user
ALL_JAVA_FIELDS - field information of stored java class accessible to user
ALL_JAVA_IMPLEMENTS - interfaces implemented by the stored java class accessible to the user
ALL_JAVA_INNERS - list of inner classes refered by the stored java class accessible to user
ALL_JAVA_LAYOUTS - class layout information about stored java class accessible to the user
ALL_JAVA_METHODS - method information of stored java class accessible to user
ALL_JAVA_NCOMPS - ncomp related information of all java classes
ALL_JAVA_RESOLVERS - resolver of java class owned by user
ALL_JAVA_THROWS - list of exceptions thrown from a method of a class accessible to user
ALL_JOBS - Synonym for USER_JOBS
ALL_JOIN_IND_COLUMNS - Join Index columns comprising the join conditions
ALL_LIBRARIES - Description of libraries accessible to the user
ALL_LOBS - Description of LOBs contained in tables accessible to the user
ALL_LOB_PARTITIONS -
ALL_LOB_SUBPARTITIONS -
ALL_LOB_TEMPLATES -
ALL_LOG_GROUPS - Log group definitions on accessible tables
ALL_LOG_GROUP_COLUMNS - Information about columns in log group definitions
ALL_METHOD_PARAMS - Description of method parameters of types accessible to the user
ALL_METHOD_RESULTS - Description of method results of types accessible to the user
ALL_MVIEWS - All materialized views in the database
ALL_MVIEW_AGGREGATES - Description of the materialized view aggregates accessible to the user
ALL_MVIEW_ANALYSIS - Description of the materialized views accessible to the user
ALL_MVIEW_COMMENTS - Comments on materialized views accessible to the user
ALL_MVIEW_DETAIL_RELATIONS - Description of the materialized view detail tables accessible to the user
ALL_MVIEW_JOINS - Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
ALL_MVIEW_KEYS - Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
ALL_MVIEW_LOGS - All materialized view logs in the database that the user can see
ALL_MVIEW_REFRESH_TIMES - Materialized views and their last refresh times for each master table that the user can look at
ALL_NESTED_TABLES - Description of nested tables in tables accessible to the user
ALL_NESTED_TABLE_COLS - Columns of nested tables
ALL_OBJECTS - Objects accessible to the user
ALL_OBJECT_TABLES - Description of all object tables accessible to the user
ALL_OBJ_COLATTRS - Description of object columns and attributes contained in the tables accessible to the user
ALL_OLAP_ALTER_SESSION - Synonym for V$OLAP_ALTER_SESSION
ALL_OPANCILLARY - All ancillary operators available to the user
ALL_OPARGUMENTS - All arguments of the operators available to the user
ALL_OPBINDINGS - All binding functions for operators available to the user
ALL_OPERATORS - All operators available to the user
ALL_OPERATOR_COMMENTS - Comments for user-defined operators
ALL_OUTLINES - Synonym for USER_OUTLINES
ALL_OUTLINE_HINTS - Synonym for USER_OUTLINE_HINTS
ALL_PARTIAL_DROP_TABS - All tables with patially dropped columns accessible to the user
ALL_PART_COL_STATISTICS -
ALL_PART_HISTOGRAMS -
ALL_PART_INDEXES -
ALL_PART_KEY_COLUMNS -
ALL_PART_LOBS -
ALL_PART_TABLES -
ALL_PENDING_CONV_TABLES - All tables accessible to the user which are not upgraded to the latest type version
ALL_PLSQL_OBJECT_SETTINGS - Compiler settings of stored objects accessible to the user
ALL_POLICIES - All policies for objects if the user has system privileges or owns the objects
ALL_POLICY_CONTEXTS - All policy driving context defined for all synonyms, tables, or views accessable to the user
ALL_POLICY_GROUPS - All policy groups defined for any synonym, table or view accessable to the user
ALL_PROBE_OBJECTS -
ALL_PROCEDURES - Description of all procedures available to the user
ALL_PROPAGATION - Streams propagation seen by the user
ALL_PUBLISHED_COLUMNS - Source columns available for Change Data Capture
ALL_QUEUES - All queues accessible to the user
ALL_QUEUE_PUBLISHERS -
ALL_QUEUE_SUBSCRIBERS - All queue subscribers accessible to user
ALL_QUEUE_TABLES - All queue tables accessible to the user
ALL_REFRESH - All the refresh groups that the user can touch
ALL_REFRESH_CHILDREN - All the objects in refresh groups, where the user can touch the group
ALL_REFRESH_DEPENDENCIES - Description of the detail tables that materialized views depend on for refresh
ALL_REFS - Description of REF columns contained in tables accessible to the user
ALL_REGISTERED_MVIEWS - Remote materialized views of local tables that the user can see
ALL_REGISTERED_SNAPSHOTS - Remote snapshots of local tables that the user can see
ALL_REGISTRY_BANNERS -
ALL_REPAUDIT_ATTRIBUTE - Information about attributes automatically maintained for replication
ALL_REPAUDIT_COLUMN - Information about columns in all shadow tables for replicated tables which are accessible to the user
ALL_REPCAT -
ALL_REPCATLOG - Information about asynchronous administration requests
ALL_REPCOLUMN - Replicated top-level columns (table) sorted alphabetically in ascending order
ALL_REPCOLUMN_GROUP - All column groups of replicated tables which are accessible to the user
ALL_REPCONFLICT - All conflicts with available resolutions for user's replicated tables
ALL_REPDDL - Arguments that do not fit in a single repcat log record
ALL_REPFLAVORS - Flavors defined for replicated object groups
ALL_REPFLAVOR_COLUMNS - Replicated columns in flavors
ALL_REPFLAVOR_OBJECTS - Replicated objects in flavors
ALL_REPGENERATED - Objects generated to support replication
ALL_REPGENOBJECTS - Objects generated to support replication
ALL_REPGROUP - Information about replicated object groups
ALL_REPGROUPED_COLUMN - Columns in the all column groups of replicated tables which are accessible to the user
ALL_REPGROUP_PRIVILEGES - Information about users who are registered for object group privileges
ALL_REPKEY_COLUMNS - Primary columns for a table using column-level replication
ALL_REPOBJECT - Information about replicated objects
ALL_REPPARAMETER_COLUMN - All columns used for resolving conflicts in replicated tables which are accessible to the user
ALL_REPPRIORITY - Values and their corresponding priorities in all priority groups which are accessible to the user
ALL_REPPRIORITY_GROUP - Information about all priority groups which are accessible to the user
ALL_REPPROP - Propagation information about replicated objects
ALL_REPRESOLUTION - Description of all conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOLUTION_METHOD - All conflict resolution methods accessible to the user
ALL_REPRESOLUTION_STATISTICS - Statistics for conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOL_STATS_CONTROL - Information about statistics collection for conflict resolutions for replicated tables which are acc
- essible to the user
ALL_REPSCHEMA - N-way replication information
ALL_REPSITES - N-way replication information
ALL_REWRITE_EQUIVALENCES - Description of all rewrite equivalence accessible to the user
ALL_RULES - Rules seen by the user
ALL_RULESETS - Rulesets seen by the user: maintained for backward compatibility
ALL_RULE_SETS - Rule sets seen by the user
ALL_RULE_SET_RULES - Rules in all rule sets seen by the user
ALL_SCHEDULER_CHAINS - All scheduler chains in the database visible to current user
ALL_SCHEDULER_CHAIN_RULES - All rules from scheduler chains visible to the current user
ALL_SCHEDULER_CHAIN_STEPS - All steps of scheduler chains visible to the current user
ALL_SCHEDULER_GLOBAL_ATTRIBUTE - All scheduler global attributes
ALL_SCHEDULER_JOBS - All scheduler jobs visible to the user
ALL_SCHEDULER_JOB_ARGS - All arguments with set values of all scheduler jobs in the database
ALL_SCHEDULER_JOB_CLASSES - All scheduler classes visible to the user
ALL_SCHEDULER_JOB_LOG - Logged information for all scheduler jobs
ALL_SCHEDULER_JOB_RUN_DETAILS - The details of a job run
ALL_SCHEDULER_PROGRAMS - All scheduler programs visible to the user
ALL_SCHEDULER_PROGRAM_ARGS - All arguments of all scheduler programs visible to the user
ALL_SCHEDULER_RUNNING_CHAINS - All job steps of running job chains visible to the user
ALL_SCHEDULER_SCHEDULES - All schedules in the database
ALL_SCHEDULER_WINDOWS - All scheduler windows in the database
ALL_SCHEDULER_WINDOW_DETAILS - The details of a window
ALL_SCHEDULER_WINDOW_GROUPS - All scheduler window groups in the database
ALL_SCHEDULER_WINDOW_LOG - Logged information for all scheduler windows
ALL_SCHEDULER_WINGROUP_MEMBERS - Members of all scheduler window groups in the database
ALL_SECONDARY_OBJECTS - All secondary objects for domain indexes
ALL_SEC_RELEVANT_COLS - Security Relevant columns of all VPD policies for tables or views which the user has access
ALL_SEQUENCES - Description of SEQUENCEs accessible to the user
ALL_SERVICES -
ALL_SNAPSHOTS - Snapshots the user can access
ALL_SNAPSHOT_LOGS - All snapshot logs in the database that the user can see
ALL_SNAPSHOT_REFRESH_TIMES - Synonym for ALL_MVIEW_REFRESH_TIMES
ALL_SOURCE - Current source on stored objects that user is allowed to create
ALL_SOURCE_TABLES - Source tables available for Change Data Capture
ALL_SQLJ_TYPES - Description of types accessible to the user
ALL_SQLJ_TYPE_ATTRS - Description of attributes of types accessible to the user
ALL_SQLJ_TYPE_METHODS - Description of methods of types accessible to the user
ALL_SQLSET -
ALL_SQLSET_BINDS -
ALL_SQLSET_PLANS -
ALL_SQLSET_REFERENCES -
ALL_SQLSET_STATEMENTS -
ALL_STORED_SETTINGS - Parameter settings for objects accessible to the user
ALL_STREAMS_GLOBAL_RULES - Global rules created on the streams capture/apply/propagation process that interact with the queue v
- isible to the current user
ALL_STREAMS_MESSAGE_CONSUMERS - Streams messaging consumers visible to the current user
ALL_STREAMS_MESSAGE_RULES - Rules for Streams messaging visible to the current user
ALL_STREAMS_NEWLY_SUPPORTED - List of tables that are newly supported by Streams
ALL_STREAMS_RULES - Rules used by streams processes
ALL_STREAMS_SCHEMA_RULES - Rules created by streams administrative APIs on all user schemas
ALL_STREAMS_TABLE_RULES - Rules created by streams administrative APIs on tables visible to the current user
ALL_STREAMS_TRANSFORM_FUNCTION - Rules-based transform functions used by Streams
ALL_STREAMS_UNSUPPORTED - List of all the tables that are not supported by Streams in this release
ALL_SUBPARTITION_TEMPLATES -
ALL_SUBPART_COL_STATISTICS -
ALL_SUBPART_HISTOGRAMS -
ALL_SUBPART_KEY_COLUMNS -
ALL_SUBSCRIBED_COLUMNS - Change Data Capture subscribed columns
ALL_SUBSCRIBED_TABLES - Change Data Capture subscribed tables
ALL_SUBSCRIPTIONS - Change Data Capture subscriptions
ALL_SUMDELTA - Direct path load entries accessible to the user
ALL_SUMMARIES - Description of the summaries accessible to the user
ALL_SYNONYMS - All synonyms for base objects accessible to the user and session
ALL_TABLES - Description of relational tables accessible to the user
ALL_TAB_COLS - Columns of user's tables, views and clusters
ALL_TAB_COLUMNS - Columns of user's tables, views and clusters
ALL_TAB_COL_STATISTICS - Columns of user's tables, views and clusters
ALL_TAB_COMMENTS - Comments on tables and views accessible to the user
ALL_TAB_HISTOGRAMS - Histograms on columns of all tables visible to user
ALL_TAB_MODIFICATIONS - Information regarding modifications to tables
ALL_TAB_PARTITIONS -
ALL_TAB_PRIVS - Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADE - User's grants and grants on user's objects
ALL_TAB_PRIVS_RECD - Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_STATISTICS - Optimizer statistics for all tables accessible to the user
ALL_TAB_STATS_HISTORY - History of table statistics modifications
ALL_TAB_SUBPARTITIONS -
ALL_TRIGGERS - Triggers accessible to the current user
ALL_TRIGGER_COLS - Column usage in user's triggers or in triggers on user's tables
ALL_TYPES - Description of types accessible to the user
ALL_TYPE_ATTRS - Description of attributes of types accessible to the user
ALL_TYPE_METHODS - Description of methods of types accessible to the user
ALL_TYPE_VERSIONS - Description of each type version accessible to the user
ALL_UNUSED_COL_TABS - All tables with unused columns accessible to the user
ALL_UPDATABLE_COLUMNS - Description of all updatable columns
ALL_USERS - Information about all users of the database
ALL_USTATS - All statistics
ALL_VARRAYS - Description of varrays in tables accessible to the user
ALL_VIEWS - Description of views accessible to the user
ALL_WARNING_SETTINGS - Warnings ettings for objects accessible to the user
ALL_WORKSPACES -
ALL_XML_INDEXES - Description of the all XMLType indexes that the user has privileges on
ALL_XML_SCHEMAS - Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2 - Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
ALL_XML_TABLES - Description of the all XMLType tables that the user has privileges on
ALL_XML_TAB_COLS - Description of the all XMLType tables that the user has privileges on
ALL_XML_VIEWS - Description of the all XMLType views that the user has privileges on
ALL_XML_VIEW_COLS - Description of the all XMLType views that the user has privileges on

272 rows selected.

SQL> SPOOL OFF;

Latest Posts