Home

Help

Catalog Views / Data Dictionary Views

The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:

The USER, ALL, and DBA views show information about schema objects that are accessible to you, at different levels of privilege.
The V$ views show performance-related information.

Shortcuts to View Names

If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.
ALL

List of Data Dictionary Views (A-Z)

ALL_ALL_TABLES: Syntax

ALL_APPLY: Syntax

ALL_APPLY_CONFLICT_COLUMNS: Syntax

ALL_APPLY_DML_HANDLERS: Syntax

ALL_APPLY_ENQUEUE: Syntax

ALL_APPLY_ERROR: Syntax

ALL_APPLY_EXECUTE: Syntax

ALL_APPLY_KEY_COLUMNS: Syntax

ALL_APPLY_PARAMETERS: Syntax

ALL_APPLY_PROGRESS: Syntax

ALL_APPLY_TABLE_COLUMNS: Syntax

ALL_ARGUMENTS: Syntax

ALL_ASSOCIATIONS: Syntax

ALL_AUDIT_POLICIES: Syntax

ALL_AUDIT_POLICY_COLUMNS: Syntax

ALL_AWS: Syntax

ALL_AW_PS: Syntax

ALL_BASE_TABLE_MVIEWS: Syntax

ALL_CAPTURE: Syntax

ALL_CAPTURE_EXTRA_ATTRIBUTES: Syntax

ALL_CAPTURE_PARAMETERS: Syntax

ALL_CAPTURE_PREPARED_DATABASE: Syntax

ALL_CAPTURE_PREPARED_SCHEMAS: Syntax

ALL_CAPTURE_PREPARED_TABLES: Syntax

ALL_CATALOG: Syntax

ALL_CLUSTERS: Syntax

ALL_CLUSTER_HASH_EXPRESSIONS: Syntax

ALL_COLL_TYPES: Syntax

ALL_COL_COMMENTS: Syntax

ALL_COL_PRIVS: Syntax

ALL_COL_PRIVS_MADE: Syntax

ALL_COL_PRIVS_RECD: Syntax

ALL_CONSTRAINTS: Syntax

ALL_CONS_COLUMNS: Syntax

ALL_CONS_OBJ_COLUMNS: Syntax

ALL_CONTEXT: Syntax

ALL_DB_LINKS: Syntax

ALL_DEF_AUDIT_OPTS: Syntax

ALL_DEPENDENCIES: Syntax

ALL_DIMENSIONS: Syntax

ALL_DIM_ATTRIBUTES: Syntax

ALL_DIM_CHILD_OF: Syntax

ALL_DIM_HIERARCHIES: Syntax

ALL_DIM_JOIN_KEY: Syntax

ALL_DIM_LEVELS: Syntax

ALL_DIM_LEVEL_KEY: Syntax

ALL_DIRECTORIES: Syntax

ALL_ERRORS: Syntax

ALL_EVALUATION_CONTEXTS: Syntax

ALL_EVALUATION_CONTEXT_TABLES: Syntax

ALL_EVALUATION_CONTEXT_VARS: Syntax

ALL_EXTERNAL_LOCATIONS: Syntax

ALL_EXTERNAL_TABLES: Syntax

ALL_INDEXES: Syntax

ALL_INDEXTYPES: Syntax

ALL_INDEXTYPE_ARRAYTYPES: Syntax

ALL_INDEXTYPE_COMMENTS: Syntax

ALL_INDEXTYPE_OPERATORS: Syntax

ALL_IND_COLUMNS: Syntax

ALL_IND_EXPRESSIONS: Syntax

ALL_IND_PARTITIONS: Syntax

ALL_IND_STATISTICS: Syntax

ALL_IND_SUBPARTITIONS: Syntax

ALL_INTERNAL_TRIGGERS: Syntax

ALL_JAVA_ARGUMENTS: Syntax

ALL_JAVA_CLASSES: Syntax

ALL_JAVA_DERIVATIONS: Syntax

ALL_JAVA_FIELDS: Syntax

ALL_JAVA_IMPLEMENTS: Syntax

ALL_JAVA_INNERS: Syntax

ALL_JAVA_LAYOUTS: Syntax

ALL_JAVA_METHODS: Syntax

ALL_JAVA_NCOMPS: Syntax

ALL_JAVA_RESOLVERS: Syntax

ALL_JAVA_THROWS: Syntax

ALL_JOBS: Syntax

ALL_JOIN_IND_COLUMNS: Syntax

ALL_LIBRARIES: Syntax

ALL_LOBS: Syntax

ALL_LOB_PARTITIONS: Syntax

ALL_LOB_SUBPARTITIONS: Syntax

ALL_LOB_TEMPLATES: Syntax

ALL_LOG_GROUPS: Syntax

ALL_LOG_GROUP_COLUMNS: Syntax

ALL_METHOD_PARAMS: Syntax

ALL_METHOD_RESULTS: Syntax

ALL_MVIEWS: Syntax

ALL_MVIEW_AGGREGATES: Syntax

ALL_MVIEW_ANALYSIS: Syntax

ALL_MVIEW_COMMENTS: Syntax

ALL_MVIEW_DETAIL_RELATIONS: Syntax

ALL_MVIEW_JOINS: Syntax

ALL_MVIEW_KEYS: Syntax

ALL_MVIEW_LOGS: Syntax

ALL_MVIEW_REFRESH_TIMES: Syntax

ALL_NESTED_TABLES: Syntax

ALL_NESTED_TABLE_COLS: Syntax

ALL_OBJECTS: Syntax

ALL_OBJECT_TABLES: Syntax

ALL_OBJ_COLATTRS: Syntax

ALL_OPANCILLARY: Syntax

ALL_OPARGUMENTS: Syntax

ALL_OPBINDINGS: Syntax

ALL_OPERATORS: Syntax

ALL_OPERATOR_COMMENTS: Syntax

ALL_OUTLINES: Syntax

ALL_OUTLINE_HINTS: Syntax

ALL_PARTIAL_DROP_TABS: Syntax

ALL_PART_COL_STATISTICS: Syntax

ALL_PART_HISTOGRAMS: Syntax

ALL_PART_INDEXES: Syntax

ALL_PART_KEY_COLUMNS: Syntax

ALL_PART_LOBS: Syntax

ALL_PART_TABLES: Syntax

ALL_PENDING_CONV_TABLES: Syntax

ALL_PLSQL_OBJECT_SETTINGS: Syntax

ALL_POLICIES: Syntax

ALL_POLICY_CONTEXTS: Syntax

ALL_POLICY_GROUPS: Syntax

ALL_PROCEDURES: Syntax

ALL_PROPAGATION: Syntax

ALL_PUBLISHED_COLUMNS: Syntax

ALL_QUEUES: Syntax

ALL_QUEUE_TABLES: Syntax

ALL_REFRESH: Syntax

ALL_REFRESH_CHILDREN: Syntax

ALL_REFRESH_DEPENDENCIES: Syntax

ALL_REFS: Syntax

ALL_REGISTERED_MVIEWS: Syntax

ALL_REGISTRY_BANNERS: Syntax

ALL_REPCATLOG: Syntax

ALL_REPCAT_REFRESH_TEMPLATES: Syntax

ALL_REPCAT_TEMPLATE_OBJECTS: Syntax

ALL_REPCAT_TEMPLATE_PARMS: Syntax

ALL_REPCAT_TEMPLATE_SITES: Syntax

ALL_REPCAT_USER_AUTHORIZATIONS: Syntax

ALL_REPCAT_USER_PARM_VALUES: Syntax

ALL_REPCOLUMN: Syntax

ALL_REPCOLUMN_GROUP: Syntax

ALL_REPCONFLICT: Syntax

ALL_REPDDL: Syntax

ALL_REPGENOBJECTS: Syntax

ALL_REPGROUP: Syntax

ALL_REPGROUPED_COLUMN: Syntax

ALL_REPGROUP_PRIVILEGES: Syntax

ALL_REPKEY_COLUMNS: Syntax

ALL_REPOBJECT: Syntax

ALL_REPPARAMETER_COLUMN: Syntax

ALL_REPPRIORITY: Syntax

ALL_REPPRIORITY_GROUP: Syntax

ALL_REPPROP: Syntax

ALL_REPRESOLUTION: Syntax

ALL_REPRESOLUTION_METHOD: Syntax

ALL_REPRESOLUTION_STATISTICS: Syntax

ALL_REPRESOL_STATS_CONTROL: Syntax

ALL_REPSITES: Syntax

ALL_REWRITE_EQUIVALENCES: Syntax

ALL_RULES: Syntax

ALL_RULE_SETS: Syntax

ALL_RULE_SET_RULES: Syntax

ALL_SCHEDULER_JOBS: Syntax

ALL_SCHEDULER_JOB_ARGS: Syntax

ALL_SCHEDULER_JOB_CLASSES: Syntax

ALL_SCHEDULER_JOB_LOG: Syntax

ALL_SCHEDULER_JOB_RUN_DETAILS: Syntax

ALL_SCHEDULER_PROGRAMS: Syntax

ALL_SCHEDULER_PROGRAM_ARGS: Syntax

ALL_SCHEDULER_RUNNING_JOBS: Syntax

ALL_SCHEDULER_SCHEDULES: Syntax

ALL_SCHEDULER_WINDOWS: Syntax

ALL_SCHEDULER_WINDOW_DETAILS: Syntax

ALL_SCHEDULER_WINDOW_GROUPS: Syntax

ALL_SCHEDULER_WINDOW_LOG: Syntax

ALL_SCHEDULER_WINGROUP_MEMBERS: Syntax

ALL_SEC_RELEVANT_COLS: Syntax

ALL_SEQUENCES: Syntax

ALL_SERVICES: Syntax

ALL_SOURCE: Syntax

ALL_SOURCE_TABLES: Syntax

ALL_SQLJ_TYPES: Syntax

ALL_SQLJ_TYPE_ATTRS: Syntax

ALL_SQLJ_TYPE_METHODS: Syntax

ALL_STORED_SETTINGS: Syntax

ALL_STREAMS_GLOBAL_RULES: Syntax

ALL_STREAMS_MESSAGE_CONSUMERS: Syntax

ALL_STREAMS_MESSAGE_RULES: Syntax

ALL_STREAMS_NEWLY_SUPPORTED: Syntax

ALL_STREAMS_RULES: Syntax

ALL_STREAMS_SCHEMA_RULES: Syntax

ALL_STREAMS_TABLE_RULES: Syntax

ALL_STREAMS_TRANSFORM_FUNCTION: Syntax

ALL_STREAMS_UNSUPPORTED: Syntax

ALL_SUBPARTITION_TEMPLATES: Syntax

ALL_SUBPART_COL_STATISTICS: Syntax

ALL_SUBPART_HISTOGRAMS: Syntax

ALL_SUBPART_KEY_COLUMNS: Syntax

ALL_SUBSCRIBED_COLUMNS: Syntax

ALL_SUBSCRIBED_TABLES: Syntax

ALL_SUBSCRIPTIONS: Syntax

ALL_SUMDELTA: Syntax

ALL_SYNONYMS: Syntax

ALL_TABLES: Syntax

ALL_TAB_COLS: Syntax

ALL_TAB_COLUMNS: Syntax

ALL_TAB_COL_STATISTICS: Syntax

ALL_TAB_COMMENTS: Syntax

ALL_TAB_HISTOGRAMS: Syntax

ALL_TAB_MODIFICATIONS: Syntax

ALL_TAB_PARTITIONS: Syntax

ALL_TAB_PRIVS: Syntax

ALL_TAB_PRIVS_MADE: Syntax

ALL_TAB_PRIVS_RECD: Syntax

ALL_TAB_STATISTICS: Syntax

ALL_TAB_SUBPARTITIONS: Syntax

ALL_TRIGGERS: Syntax

ALL_TRIGGER_COLS: Syntax

ALL_TYPES: Syntax

ALL_TYPE_ATTRS: Syntax

ALL_TYPE_METHODS: Syntax

ALL_TYPE_VERSIONS: Syntax

ALL_UNUSED_COL_TABS: Syntax

ALL_UPDATABLE_COLUMNS: Syntax

ALL_USERS: Syntax

ALL_USTATS: Syntax

ALL_VARRAYS: Syntax

ALL_VIEWS: Syntax

ALL_WARNING_SETTINGS: Syntax

ALL_XML_SCHEMAS: Syntax

ALL_XML_TABLES: Syntax

ALL_XML_TAB_COLS: Syntax

ALL_XML_VIEWS: Syntax

ALL_XML_VIEW_COLS: Syntax