Catalog Views / Data Dictionary Views

DBA_2PC_NEIGHBORS: Syntax

DBA_2PC_PENDING: Syntax

DBA_ADVISOR_ACTIONS: Syntax

DBA_ADVISOR_COMMANDS: Syntax

DBA_ADVISOR_DEFINITIONS: Syntax

DBA_ADVISOR_DEF_PARAMETERS: Syntax

DBA_ADVISOR_FINDINGS: Syntax

DBA_ADVISOR_JOURNAL: Syntax

DBA_ADVISOR_LOG: Syntax

DBA_ADVISOR_OBJECTS: Syntax

DBA_ADVISOR_OBJECT_TYPES: Syntax

DBA_ADVISOR_PARAMETERS: Syntax

DBA_ADVISOR_RATIONALE: Syntax

DBA_ADVISOR_RECOMMENDATIONS: Syntax

DBA_ADVISOR_SQLA_REC_SUM: Syntax

DBA_ADVISOR_SQLA_WK_MAP: Syntax

DBA_ADVISOR_SQLA_WK_STMTS: Syntax

DBA_ADVISOR_SQLW_JOURNAL: Syntax

DBA_ADVISOR_SQLW_PARAMETERS: Syntax

DBA_ADVISOR_SQLW_STMTS: Syntax

DBA_ADVISOR_SQLW_SUM: Syntax

DBA_ADVISOR_SQLW_TABLES: Syntax

DBA_ADVISOR_SQLW_TEMPLATES: Syntax

DBA_ADVISOR_TASKS: Syntax

DBA_ADVISOR_TEMPLATES: Syntax

DBA_ADVISOR_USAGE: Syntax

DBA_ALERT_HISTORY: Syntax

DBA_ALL_TABLES: Syntax

DBA_APPLICATION_ROLES: Syntax

DBA_APPLY: Syntax

DBA_APPLY_CONFLICT_COLUMNS: Syntax

DBA_APPLY_DML_HANDLERS: Syntax

DBA_APPLY_ENQUEUE: Syntax

DBA_APPLY_ERROR: Syntax

DBA_APPLY_EXECUTE: Syntax

DBA_APPLY_INSTANTIATED_GLOBAL: Syntax

DBA_APPLY_INSTANTIATED_OBJECTS: Syntax

DBA_APPLY_INSTANTIATED_SCHEMAS: Syntax

DBA_APPLY_KEY_COLUMNS: Syntax

DBA_APPLY_OBJECT_DEPENDENCIES: Syntax

DBA_APPLY_PARAMETERS: Syntax

DBA_APPLY_PROGRESS: Syntax

DBA_APPLY_SPILL_TXN: Syntax

DBA_APPLY_TABLE_COLUMNS: Syntax

DBA_APPLY_VALUE_DEPENDENCIES: Syntax

DBA_AQ_AGENTS: Syntax

DBA_AQ_AGENT_PRIVS: Syntax

DBA_ASSOCIATIONS: Syntax

DBA_ATTRIBUTE_TRANSFORMATIONS: Syntax

DBA_AUDIT_EXISTS: Syntax

DBA_AUDIT_OBJECT: Syntax

DBA_AUDIT_POLICIES: Syntax

DBA_AUDIT_POLICY_COLUMNS: Syntax

DBA_AUDIT_SESSION: Syntax

DBA_AUDIT_STATEMENT: Syntax

DBA_AUDIT_TRAIL: Syntax

DBA_AUTO_SEGADV_CTL: Syntax

DBA_AUTO_SEGADV_SUMMARY: Syntax

DBA_AWS: Syntax

DBA_AW_PS: Syntax

DBA_BASE_TABLE_MVIEWS: Syntax

DBA_BLOCKERS: Syntax

DBA_CAPTURE: Syntax

DBA_CAPTURE_EXTRA_ATTRIBUTES: Syntax

DBA_CAPTURE_PARAMETERS: Syntax

DBA_CAPTURE_PREPARED_DATABASE: Syntax

DBA_CAPTURE_PREPARED_SCHEMAS: Syntax

DBA_CAPTURE_PREPARED_TABLES: Syntax

DBA_CATALOG: Syntax

DBA_CHANGE_NOTIFICATION_REGS: Syntax

DBA_CLUSTERS: Syntax

DBA_CLUSTER_HASH_EXPRESSIONS: Syntax

DBA_CLU_COLUMNS: Syntax

DBA_COLL_TYPES: Syntax

DBA_COL_COMMENTS: Syntax

DBA_COL_PRIVS: Syntax

DBA_COMMON_AUDIT_TRAIL: Syntax

DBA_CONNECT_ROLE_GRANTEES: Syntax

DBA_CONSTRAINTS: Syntax

DBA_CONS_OBJ_COLUMNS: Syntax

DBA_CONTEXT: Syntax

DBA_CPU_USAGE_STATISTICS: Syntax

DBA_DATAPUMP_JOBS: Syntax

DBA_DATAPUMP_SESSIONS: Syntax

DBA_DATA_FILES: Syntax

DBA_DB_LINKS: Syntax

DBA_DDL_LOCKS: Syntax

DBA_DEPENDENCIES: Syntax

DBA_DIMENSIONS: Syntax

DBA_DIM_ATTRIBUTES: Syntax

DBA_DIM_CHILD_OF: Syntax

DBA_DIM_HIERARCHIES: Syntax

DBA_DIM_JOIN_KEY: Syntax

DBA_DIM_LEVELS: Syntax

DBA_DIM_LEVEL_KEY: Syntax

DBA_DIRECTORIES: Syntax

DBA_DML_LOCKS: Syntax

DBA_DMT_FREE_SPACE: Syntax

DBA_DMT_USED_EXTENTS: Syntax

DBA_ENABLED_AGGREGATIONS: Syntax

DBA_ENABLED_TRACES: Syntax

DBA_ENCRYPTED_COLUMNS: Syntax

DBA_EPG_DAD_AUTHORIZATION: Syntax

DBA_ERRORS: Syntax

DBA_EVALUATION_CONTEXTS: Syntax

DBA_EVALUATION_CONTEXT_TABLES: Syntax

DBA_EVALUATION_CONTEXT_VARS: Syntax

DBA_EXP_FILES: Syntax

DBA_EXP_OBJECTS: Syntax

DBA_EXP_VERSION: Syntax

DBA_EXTENTS: Syntax

DBA_EXTERNAL_LOCATIONS: Syntax

DBA_EXTERNAL_TABLES: Syntax

DBA_FEATURE_USAGE_STATISTICS: Syntax

DBA_FGA_AUDIT_TRAIL: Syntax

DBA_FILE_GROUPS: Syntax

DBA_FILE_GROUP_EXPORT_INFO: Syntax

DBA_FILE_GROUP_FILES: Syntax

DBA_FILE_GROUP_TABLES: Syntax

DBA_FILE_GROUP_TABLESPACES: Syntax

DBA_FILE_GROUP_VERSIONS: Syntax

DBA_FREE_SPACE: Syntax

DBA_FREE_SPACE_COALESCED: Syntax

DBA_HIGH_WATER_MARK_STATISTICS: Syntax

DBA_HIST_ACTIVE_SESS_HISTORY: Syntax

DBA_HIST_BASELINE: Syntax

DBA_HIST_BG_EVENT_SUMMARY: Syntax

DBA_HIST_BUFFERED_QUEUES: Syntax

DBA_HIST_BUFFERED_SUBSCRIBERS: Syntax

DBA_HIST_BUFFER_POOL_STAT: Syntax

DBA_HIST_COMP_IOSTAT: Syntax

DBA_HIST_CR_BLOCK_SERVER: Syntax

DBA_HIST_CURRENT_BLOCK_SERVER: Syntax

DBA_HIST_DATABASE_INSTANCE: Syntax

DBA_HIST_DATAFILE: Syntax

DBA_HIST_DB_CACHE_ADVICE: Syntax

DBA_HIST_DLM_MISC: Syntax

DBA_HIST_ENQUEUE_STAT: Syntax

DBA_HIST_EVENT_NAME: Syntax

DBA_HIST_FILEMETRIC_HISTORY: Syntax

DBA_HIST_FILESTATXS: Syntax

DBA_HIST_INSTANCE_RECOVERY: Syntax

DBA_HIST_INST_CACHE_TRANSFER: Syntax

DBA_HIST_JAVA_POOL_ADVICE: Syntax

DBA_HIST_LATCH: Syntax

DBA_HIST_LATCH_CHILDREN: Syntax

DBA_HIST_LATCH_MISSES_SUMMARY: Syntax

DBA_HIST_LATCH_NAME: Syntax

DBA_HIST_LATCH_PARENT: Syntax

DBA_HIST_LIBRARYCACHE: Syntax

DBA_HIST_LOG: Syntax

DBA_HIST_METRIC_NAME: Syntax

DBA_HIST_MTTR_TARGET_ADVICE: Syntax

DBA_HIST_OPTIMIZER_ENV: Syntax

DBA_HIST_OSSTAT: Syntax

DBA_HIST_OSSTAT_NAME: Syntax

DBA_HIST_PARAMETER: Syntax

DBA_HIST_PARAMETER_NAME: Syntax

DBA_HIST_PGASTAT: Syntax

DBA_HIST_PGA_TARGET_ADVICE: Syntax

DBA_HIST_PROCESS_MEM_SUMMARY: Syntax

DBA_HIST_RESOURCE_LIMIT: Syntax

DBA_HIST_ROWCACHE_SUMMARY: Syntax

DBA_HIST_RULE_SET: Syntax

DBA_HIST_SEG_STAT: Syntax

DBA_HIST_SEG_STAT_OBJ: Syntax

DBA_HIST_SERVICE_NAME: Syntax

DBA_HIST_SERVICE_STAT: Syntax

DBA_HIST_SERVICE_WAIT_CLASS: Syntax

DBA_HIST_SESSMETRIC_HISTORY: Syntax

DBA_HIST_SESS_TIME_STATS: Syntax

DBA_HIST_SGA: Syntax

DBA_HIST_SGASTAT: Syntax

DBA_HIST_SGA_TARGET_ADVICE: Syntax

DBA_HIST_SHARED_POOL_ADVICE: Syntax

DBA_HIST_SNAPSHOT: Syntax

DBA_HIST_SNAP_ERROR: Syntax

DBA_HIST_SQLBIND: Syntax

DBA_HIST_SQLSTAT: Syntax

DBA_HIST_SQLTEXT: Syntax

DBA_HIST_SQL_BIND_METADATA: Syntax

DBA_HIST_SQL_PLAN: Syntax

DBA_HIST_SQL_SUMMARY: Syntax

DBA_HIST_SQL_WORKAREA_HSTGRM: Syntax

DBA_HIST_STAT_NAME: Syntax

DBA_HIST_STREAMS_APPLY_SUM: Syntax

DBA_HIST_STREAMS_CAPTURE: Syntax

DBA_HIST_STREAMS_POOL_ADVICE: Syntax

DBA_HIST_SYSMETRIC_HISTORY: Syntax

DBA_HIST_SYSMETRIC_SUMMARY: Syntax

DBA_HIST_SYSSTAT: Syntax

DBA_HIST_SYSTEM_EVENT: Syntax

DBA_HIST_SYS_TIME_MODEL: Syntax

DBA_HIST_TABLESPACE_STAT: Syntax

DBA_HIST_TBSPC_SPACE_USAGE: Syntax

DBA_HIST_TEMPFILE: Syntax

DBA_HIST_TEMPSTATXS: Syntax

DBA_HIST_THREAD: Syntax

DBA_HIST_UNDOSTAT: Syntax

DBA_HIST_WAITCLASSMET_HISTORY: Syntax

DBA_HIST_WAITSTAT: Syntax

DBA_HIST_WR_CONTROL: Syntax

DBA_INDEXES: Syntax

DBA_INDEXTYPES: Syntax

DBA_INDEXTYPE_ARRAYTYPES: Syntax

DBA_INDEXTYPE_COMMENTS: Syntax

DBA_INDEXTYPE_OPERATORS: Syntax

DBA_IND_COLUMNS: Syntax

DBA_IND_EXPRESSIONS: Syntax

DBA_IND_PARTITIONS: Syntax

DBA_IND_STATISTICS: Syntax

DBA_IND_SUBPARTITIONS: Syntax

DBA_INTERNAL_TRIGGERS: Syntax

DBA_JAVA_ARGUMENTS: Syntax

DBA_JAVA_CLASSES: Syntax

DBA_JAVA_DERIVATIONS: Syntax

DBA_JAVA_FIELDS: Syntax

DBA_JAVA_IMPLEMENTS: Syntax

DBA_JAVA_INNERS: Syntax

DBA_JAVA_LAYOUTS: Syntax

DBA_JAVA_METHODS: Syntax

DBA_JAVA_NCOMPS: Syntax

DBA_JAVA_POLICY: Syntax

DBA_JAVA_RESOLVERS: Syntax

DBA_JAVA_THROWS: Syntax

DBA_JOBS: Syntax

DBA_JOBS_RUNNING: Syntax

DBA_JOIN_IND_COLUMNS: Syntax

DBA_KGLLOCK: Syntax

DBA_LIBRARIES: Syntax

DBA_LMT_FREE_SPACE: Syntax

DBA_LMT_USED_EXTENTS: Syntax

DBA_LOBS: Syntax

DBA_LOB_PARTITIONS: Syntax

DBA_LOB_SUBPARTITIONS: Syntax

DBA_LOB_TEMPLATES: Syntax

DBA_LOCK: Syntax

DBA_LOCKS: Syntax

DBA_LOCK_INTERNAL: Syntax

DBA_LOGMNR_LOG: Syntax

DBA_LOGMNR_PURGED_LOG: Syntax

DBA_LOGMNR_SESSION: Syntax

DBA_LOGSTDBY_EVENTS: Syntax

DBA_LOGSTDBY_HISTORY: Syntax

DBA_LOGSTDBY_LOG: Syntax

DBA_LOGSTDBY_NOT_UNIQUE: Syntax

DBA_LOGSTDBY_PARAMETERS: Syntax

DBA_LOGSTDBY_PROGRESS: Syntax

DBA_LOGSTDBY_SKIP: Syntax

DBA_LOGSTDBY_SKIP_TRANSACTION: Syntax

DBA_LOGSTDBY_UNSUPPORTED: Syntax

DBA_LOG_GROUPS: Syntax

DBA_LOG_GROUP_COLUMNS: Syntax

DBA_METHOD_PARAMS: Syntax

DBA_METHOD_RESULTS: Syntax

DBA_MVIEWS: Syntax

DBA_MVIEW_AGGREGATES: Syntax

DBA_MVIEW_ANALYSIS: Syntax

DBA_MVIEW_COMMENTS: Syntax

DBA_MVIEW_DETAIL_RELATIONS: Syntax

DBA_MVIEW_JOINS: Syntax

DBA_MVIEW_KEYS: Syntax

DBA_MVIEW_LOGS: Syntax

DBA_MVIEW_LOG_FILTER_COLS: Syntax

DBA_MVIEW_REFRESH_TIMES: Syntax

DBA_NESTED_TABLES: Syntax

DBA_NESTED_TABLE_COLS: Syntax

DBA_OBJECTS: Syntax

DBA_OBJECT_SIZE: Syntax

DBA_OBJECT_TABLES: Syntax

DBA_OBJ_AUDIT_OPTS: Syntax

DBA_OBJ_COLATTRS: Syntax

DBA_OPANCILLARY: Syntax

DBA_OPARGUMENTS: Syntax

DBA_OPBINDINGS: Syntax

DBA_OPERATORS: Syntax

DBA_OPERATOR_COMMENTS: Syntax

DBA_OPTSTAT_OPERATIONS: Syntax

DBA_ORPHAN_KEY_TABLE: Syntax

DBA_OUTLINES: Syntax

DBA_OUTLINE_HINTS: Syntax

DBA_OUTSTANDING_ALERTS: Syntax

DBA_PARTIAL_DROP_TABS: Syntax

DBA_PART_COL_STATISTICS: Syntax

DBA_PART_HISTOGRAMS: Syntax

DBA_PART_INDEXES: Syntax

DBA_PART_KEY_COLUMNS: Syntax

DBA_PART_LOBS: Syntax

DBA_PART_TABLES: Syntax

DBA_PENDING_CONV_TABLES: Syntax

DBA_PENDING_TRANSACTIONS: Syntax

DBA_PLSQL_OBJECT_SETTINGS: Syntax

DBA_POLICIES: Syntax

DBA_POLICY_CONTEXTS: Syntax

DBA_POLICY_GROUPS: Syntax

DBA_PRIV_AUDIT_OPTS: Syntax

DBA_PROCEDURES: Syntax

DBA_PROFILES: Syntax

DBA_PROPAGATION: Syntax

DBA_PROXIES: Syntax

DBA_PUBLISHED_COLUMNS: Syntax

DBA_QUEUES: Syntax

DBA_QUEUE_SCHEDULES: Syntax

DBA_QUEUE_SUBSCRIBERS: Syntax

DBA_QUEUE_TABLES: Syntax

DBA_RCHILD: Syntax

DBA_RECOVERABLE_SCRIPT: Syntax

DBA_RECOVERABLE_SCRIPT_BLOCKS: Syntax

DBA_RECOVERABLE_SCRIPT_ERRORS: Syntax

DBA_RECOVERABLE_SCRIPT_PARAMS: Syntax

DBA_RECYCLEBIN: Syntax

DBA_REDEFINITION_ERRORS: Syntax

DBA_REDEFINITION_OBJECTS: Syntax

DBA_REFRESH: Syntax

DBA_REFRESH_CHILDREN: Syntax

DBA_REFS: Syntax

DBA_REGISTERED_ARCHIVED_LOG: Syntax

DBA_REGISTERED_MVIEWS: Syntax

DBA_REGISTERED_MVIEW_GROUPS: Syntax

DBA_REGISTRY: Syntax

DBA_REGISTRY_HIERARCHY: Syntax

DBA_REGISTRY_HISTORY: Syntax

DBA_REGISTRY_LOG: Syntax

DBA_REPAIR_TABLE: Syntax

DBA_RESOURCE_INCARNATIONS: Syntax

DBA_RESUMABLE: Syntax

DBA_REWRITE_EQUIVALENCES: Syntax

DBA_RGROUP: Syntax

DBA_ROLES: Syntax

DBA_ROLE_PRIVS: Syntax

DBA_ROLLBACK_SEGS: Syntax

DBA_RSRC_CONSUMER_GROUPS: Syntax

DBA_RSRC_CONSUMER_GROUP_PRIVS: Syntax

DBA_RSRC_GROUP_MAPPINGS: Syntax

DBA_RSRC_MANAGER_SYSTEM_PRIVS: Syntax

DBA_RSRC_MAPPING_PRIORITY: Syntax

DBA_RSRC_PLANS: Syntax

DBA_RSRC_PLAN_DIRECTIVES: Syntax

DBA_RULES: Syntax

DBA_RULE_SETS: Syntax

DBA_RULE_SET_RULES: Syntax

DBA_SCHEDULER_CHAINS: Syntax

DBA_SCHEDULER_CHAIN_RULES: Syntax

DBA_SCHEDULER_CHAIN_STEPS: Syntax

DBA_SCHEDULER_GLOBAL_ATTRIBUTE: Syntax

DBA_SCHEDULER_JOBS: Syntax

DBA_SCHEDULER_JOB_ARGS: Syntax

DBA_SCHEDULER_JOB_CLASSES: Syntax

DBA_SCHEDULER_JOB_LOG: Syntax

DBA_SCHEDULER_JOB_RUN_DETAILS: Syntax

DBA_SCHEDULER_PROGRAMS: Syntax

DBA_SCHEDULER_PROGRAM_ARGS: Syntax

DBA_SCHEDULER_RUNNING_CHAINS: Syntax

DBA_SCHEDULER_RUNNING_JOBS: Syntax

DBA_SCHEDULER_SCHEDULES: Syntax

DBA_SCHEDULER_WINDOWS: Syntax

DBA_SCHEDULER_WINDOW_DETAILS: Syntax

DBA_SCHEDULER_WINDOW_GROUPS: Syntax

DBA_SCHEDULER_WINDOW_LOG: Syntax

DBA_SCHEDULER_WINGROUP_MEMBERS: Syntax

DBA_SEC_RELEVANT_COLS: Syntax

DBA_SEGMENTS: Syntax

DBA_SEGMENTS_OLD: Syntax

DBA_SEQUENCES: Syntax

DBA_SERVER_REGISTRY: Syntax

DBA_SERVICES: Syntax

DBA_SOURCE: Syntax

DBA_SOURCE_TABLES: Syntax

DBA_SQLJ_TYPES: Syntax

DBA_SQLJ_TYPE_ATTRS: Syntax

DBA_SQLJ_TYPE_METHODS: Syntax

DBA_SQLSET: Syntax

DBA_SQLSET_BINDS: Syntax

DBA_SQLSET_PLANS: Syntax

DBA_SQLSET_REFERENCES: Syntax

DBA_SQLSET_STATEMENTS: Syntax

DBA_SQLTUNE_BINDS: Syntax

DBA_SQLTUNE_PLANS: Syntax

DBA_SQLTUNE_RATIONALE_PLAN: Syntax

DBA_SQLTUNE_STATISTICS: Syntax

DBA_SQL_PROFILES: Syntax

DBA_STMT_AUDIT_OPTS: Syntax

DBA_STORED_SETTINGS: Syntax

DBA_STREAMS_ADD_COLUMN: Syntax

DBA_STREAMS_ADMINISTRATOR: Syntax

DBA_STREAMS_DELETE_COLUMN: Syntax

DBA_STREAMS_GLOBAL_RULES: Syntax

DBA_STREAMS_MESSAGE_CONSUMERS: Syntax

DBA_STREAMS_MESSAGE_RULES: Syntax

DBA_STREAMS_NEWLY_SUPPORTED: Syntax

DBA_STREAMS_RENAME_COLUMN: Syntax

DBA_STREAMS_RENAME_SCHEMA: Syntax

DBA_STREAMS_RENAME_TABLE: Syntax

DBA_STREAMS_RULES: Syntax

DBA_STREAMS_SCHEMA_RULES: Syntax

DBA_STREAMS_TABLE_RULES: Syntax

DBA_STREAMS_TRANSFORMATIONS: Syntax

DBA_STREAMS_TRANSFORM_FUNCTION: Syntax

DBA_STREAMS_UNSUPPORTED: Syntax

DBA_SUBPARTITION_TEMPLATES: Syntax

DBA_SUBPART_COL_STATISTICS: Syntax

DBA_SUBPART_HISTOGRAMS: Syntax

DBA_SUBPART_KEY_COLUMNS: Syntax

DBA_SUBSCRIBED_COLUMNS: Syntax

DBA_SUBSCRIBED_TABLES: Syntax

DBA_SUBSCRIPTIONS: Syntax

DBA_SYNONYMS: Syntax

DBA_SYS_PRIVS: Syntax

DBA_TABLES: Syntax

DBA_TABLESPACES: Syntax

DBA_TABLESPACE_GROUPS: Syntax

DBA_TAB_COLS: Syntax

DBA_TAB_COLUMNS: Syntax

DBA_TAB_COL_STATISTICS: Syntax

DBA_TAB_COMMENTS: Syntax

DBA_TAB_HISTOGRAMS: Syntax

DBA_TAB_MODIFICATIONS: Syntax

DBA_TAB_PARTITIONS: Syntax

DBA_TAB_PRIVS: Syntax

DBA_TAB_STATISTICS: Syntax

DBA_TAB_STATS_HISTORY: Syntax

DBA_TAB_SUBPARTITIONS: Syntax

DBA_TEMP_FILES: Syntax

DBA_THRESHOLDS: Syntax

DBA_TRANSFORMATIONS: Syntax

DBA_TRIGGERS: Syntax

DBA_TRIGGER_COLS: Syntax

DBA_TSM_DESTINATION: Syntax

DBA_TSM_SOURCE: Syntax

DBA_TS_QUOTAS: Syntax

DBA_TUNE_MVIEW: Syntax

DBA_TYPES: Syntax

DBA_TYPE_ATTRS: Syntax

DBA_TYPE_METHODS: Syntax

DBA_TYPE_VERSIONS: Syntax

DBA_UNDO_EXTENTS: Syntax

DBA_UNUSED_COL_TABS: Syntax

DBA_UPDATABLE_COLUMNS: Syntax

DBA_USERS: Syntax

DBA_USTATS: Syntax

DBA_VARRAYS: Syntax

DBA_VIEWS: Syntax

DBA_WAITERS: Syntax

DBA_WARNING_SETTINGS: Syntax

DBA_WORKLOAD_CAPTURES: Syntax

DBA_WORKLOAD_FILTERS: Syntax

DBA_XML_SCHEMAS: Syntax

DBA_XML_TABLES: Syntax

DBA_XML_TAB_COLS: Syntax

DBA_XML_VIEWS: Syntax

DBA_XML_VIEW_COLS: Syntax