|
Oracle Data Dictionary Views
A dump of the Oracle 8.1.6 Data Dictionary. Also see Oracle V$ performance views.
DBA_2PC_NEIGHBORS DBA_2PC_PENDING DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES DBA_ANALYZE_OBJECTS ALL_ARGUMENTS USER_ARGUMENTS DBA_ASSOCIATIONS ALL_ASSOCIATIONS USER_ASSOCIATIONS DBA_AUDIT_EXISTS DBA_AUDIT_OBJECT USER_AUDIT_OBJECT DBA_AUDIT_SESSION USER_AUDIT_SESSION DBA_AUDIT_STATEMENT USER_AUDIT_STATEMENT DBA_AUDIT_TRAIL USER_AUDIT_TRAIL c DBA_CATALOG ALL_CATALOG USER_CATALOG CATALOG SYSCATALOG SYSCATALOG_ DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA_CLUSTER_HASH_EXPRESSIONS ALL_CLUSTER_HASH_EXPRESSIONS USER_CLUSTER_HASH_EXPRESSIONS DBA_CLU_COLUMNS USER_CLU_COLUMNS CODE_PIECES CODE_SIZE DBA_COLL_TYPES ALL_COLL_TYPES USER_COLL_TYPES COL DBA_COL_COMMENTS ALL_COL_COMMENTS USER_COL_COMMENTS DBA_COL_PRIVS ALL_COL_PRIVS USER_COL_PRIVS COLUMN_PRIVILEGES ALL_COL_PRIVS_MADE USER_COL_PRIVS_MADE ALL_COL_PRIVS_RECD USER_COL_PRIVS_RECD DBA_CONSTRAINTS ALL_CONSTRAINTS USER_CONSTRAINTS SM$INTEGRITY_CONS DBA_CONS_COLUMNS ALL_CONS_COLUMNS USER_CONS_COLUMNS DBA_CONTEXT ALL_CONTEXT d DBA_DATA_FILES DATABASE_COMPATIBLE_LEVEL DBA_DB_LINKS ALL_DB_LINKS USER_DB_LINKS ALL_DEF_AUDIT_OPTS DBA_DEPENDENCIES ALL_DEPENDENCIES USER_DEPENDENCIES DICTIONARY DICT_COLUMNS DISK_AND_FIXED_OBJECTS DBA_DIMENSIONS ALL_DIMENSIONS USER_DIMENSIONS DBA_DIM_ATTRIBUTES ALL_DIM_ATTRIBUTES USER_DIM_ATTRIBUTES DBA_DIM_CHILD_OF ALL_DIM_CHILD_OF USER_DIM_CHILD_OF DBA_DIM_HIERARCHIES ALL_DIM_HIERARCHIES USER_DIM_HIERARCHIES DBA_DIM_JOIN_KEY ALL_DIM_JOIN_KEY USER_DIM_JOIN_KEY DBA_DIM_LEVELS ALL_DIM_LEVELS USER_DIM_LEVELS DBA_DIM_LEVEL_KEY ALL_DIM_LEVEL_KEY USER_DIM_LEVEL_KEY DBA_DIRECTORIES ALL_DIRECTORIES DBA_DMT_FREE_SPACE DBA_DMT_USED_EXTENTS e DBA_ERRORS ALL_ERRORS USER_ERRORS ERROR_SIZE DBA_EXP_FILES DBA_EXP_OBJECTS DBA_EXP_VERSION DBA_EXTENTS USER_EXTENTS f FILEXT$ SYSFILES DBA_FREE_SPACE USER_FREE_SPACE DBA_FREE_SPACE_COALESCED DBA_FREE_SPACE_COALESCED_TMP1 DBA_FREE_SPACE_COALESCED_TMP2 DBA_FREE_SPACE_COALESCED_TMP3 g GLOBAL_NAME i ALL_IDS DBA_INDEXES ALL_INDEXES USER_INDEXES INDEX_HISTOGRAM INDEX_STATS DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS DBA_IND_COLUMNS ALL_IND_COLUMNS USER_IND_COLUMNS DBA_IND_EXPRESSIONS ALL_IND_EXPRESSIONS USER_IND_EXPRESSIONS DBA_IND_PARTITIONS ALL_IND_PARTITIONS USER_IND_PARTITIONS DBA_IND_SUBPARTITIONS ALL_IND_SUBPARTITIONS USER_IND_SUBPARTITIONS DBA_INTERNAL_TRIGGERS ALL_INTERNAL_TRIGGERS USER_INTERNAL_TRIGGERS j DBA_JAVA_POLICY USER_JAVA_POLICY DBA_JOBS USER_JOBS DBA_JOBS_RUNNING l DBA_LIBRARIES ALL_LIBRARIES USER_LIBRARIES DBA_LMT_FREE_SPACE DBA_LMT_USED_EXTENTS DBA_LOBS ALL_LOBS USER_LOBS DBA_LOB_PARTITIONS ALL_LOB_PARTITIONS USER_LOB_PARTITIONS DBA_LOB_SUBPARTITIONS ALL_LOB_SUBPARTITIONS USER_LOB_SUBPARTITIONS m DBA_METHOD_PARAMS ALL_METHOD_PARAMS USER_METHOD_PARAMS DBA_METHOD_RESULTS ALL_METHOD_RESULTS USER_METHOD_RESULTS DBA_MVIEWS ALL_MVIEWS USER_MVIEWS DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES DBA_MVIEW_ANALYSIS ALL_MVIEW_ANALYSIS USER_MVIEW_ANALYSIS DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS DBA_MVIEW_JOINS ALL_MVIEW_JOINS USER_MVIEW_JOINS DBA_MVIEW_KEYS ALL_MVIEW_KEYS USER_MVIEW_KEYS n DBA_NESTED_TABLES ALL_NESTED_TABLES USER_NESTED_TABLES NLS_DATABASE_PARAMETERS NLS_INSTANCE_PARAMETERS NLS_SESSION_PARAMETERS o DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS DBA_OBJECT_SIZE USER_OBJECT_SIZE DBA_OBJECT_TABLES ALL_OBJECT_TABLES USER_OBJECT_TABLES DBA_OBJ_AUDIT_OPTS USER_OBJ_AUDIT_OPTS DBA_OPANCILLARY ALL_OPANCILLARY USER_OPANCILLARY DBA_OPARGUMENTS ALL_OPARGUMENTS USER_OPARGUMENTS DBA_OPBINDINGS ALL_OPBINDINGS USER_OPBINDINGS DBA_OPERATORS ALL_OPERATORS USER_OPERATORS DBA_OUTLINES USER_OUTLINES DBA_OUTLINE_HINTS USER_OUTLINE_HINTS p DBA_PARTIAL_DROP_TABS ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS DBA_PART_HISTOGRAMS ALL_PART_HISTOGRAMS USER_PART_HISTOGRAMS DBA_PART_INDEXES ALL_PART_INDEXES USER_PART_INDEXES DBA_PART_KEY_COLUMNS ALL_PART_KEY_COLUMNS USER_PART_KEY_COLUMNS DBA_PART_LOBS ALL_PART_LOBS USER_PART_LOBS DBA_PART_TABLES ALL_PART_TABLES USER_PART_TABLES USER_PASSWORD_LIMITS DBA_PENDING_TRANSACTIONS DBA_POLICIES ALL_POLICIES USER_POLICIES DBA_PRIV_AUDIT_OPTS ALL_PROBE_OBJECTS DBA_PROFILES q DBA_QUEUES ALL_QUEUES USER_QUEUES QUEUE_PRIVILEGES DBA_QUEUE_SCHEDULES USER_QUEUE_SCHEDULES DBA_QUEUE_TABLES ALL_QUEUE_TABLES USER_QUEUE_TABLES r DBA_RCHILD DBA_REFRESH ALL_REFRESH USER_REFRESH DBA_REFRESH_CHILDREN ALL_REFRESH_CHILDREN USER_REFRESH_CHILDREN ALL_REFRESH_DEPENDENCIES DBA_REFS ALL_REFS USER_REFS DBA_REGISTERED_SNAPSHOTS ALL_REGISTERED_SNAPSHOTS USER_REGISTERED_SNAPSHOTS DBA_REGISTERED_SNAPSHOT_GROUPS DBA_REPAUDIT_ATTRIBUTE ALL_REPAUDIT_ATTRIBUTE USER_REPAUDIT_ATTRIBUTE DBA_REPAUDIT_COLUMN ALL_REPAUDIT_COLUMN USER_REPAUDIT_COLUMN DBA_REPCAT ALL_REPCAT USER_REPCAT DBA_REPCATLOG ALL_REPCATLOG USER_REPCATLOG DBA_REPCAT_REFRESH_TEMPLATES ALL_REPCAT_REFRESH_TEMPLATES USER_REPCAT_REFRESH_TEMPLATES DBA_REPCAT_TEMPLATE_OBJECTS ALL_REPCAT_TEMPLATE_OBJECTS USER_REPCAT_TEMPLATE_OBJECTS DBA_REPCAT_TEMPLATE_PARMS ALL_REPCAT_TEMPLATE_PARMS USER_REPCAT_TEMPLATE_PARMS DBA_REPCAT_TEMPLATE_SITES ALL_REPCAT_TEMPLATE_SITES USER_REPCAT_TEMPLATE_SITES DBA_REPCAT_USER_AUTHORIZATIONS ALL_REPCAT_USER_AUTHORIZATIONS USER_REPCAT_USER_AUTHORIZATION DBA_REPCAT_USER_PARM_VALUES ALL_REPCAT_USER_PARM_VALUES USER_REPCAT_USER_PARM_VALUES _ALL_REPCOLUMN DBA_REPCOLUMN ALL_REPCOLUMN USER_REPCOLUMN DBA_REPCOLUMN_GROUP ALL_REPCOLUMN_GROUP USER_REPCOLUMN_GROUP DBA_REPCONFLICT ALL_REPCONFLICT USER_REPCONFLICT DBA_REPDDL ALL_REPDDL USER_REPDDL DBA_REPFLAVORS ALL_REPFLAVORS USER_REPFLAVORS DBA_REPFLAVOR_COLUMNS ALL_REPFLAVOR_COLUMNS USER_REPFLAVOR_COLUMNS _ALL_REPFLAVOR_OBJECTS DBA_REPFLAVOR_OBJECTS ALL_REPFLAVOR_OBJECTS USER_REPFLAVOR_OBJECTS DBA_REPGENERATED ALL_REPGENERATED USER_REPGENERATED DBA_REPGENOBJECTS ALL_REPGENOBJECTS USER_REPGENOBJECTS DBA_REPGROUP ALL_REPGROUP USER_REPGROUP DBA_REPGROUPED_COLUMN ALL_REPGROUPED_COLUMN USER_REPGROUPED_COLUMN DBA_REPGROUP_PRIVILEGES ALL_REPGROUP_PRIVILEGES USER_REPGROUP_PRIVILEGES DBA_REPKEY_COLUMNS ALL_REPKEY_COLUMNS USER_REPKEY_COLUMNS DBA_REPOBJECT ALL_REPOBJECT USER_REPOBJECT DBA_REPPARAMETER_COLUMN ALL_REPPARAMETER_COLUMN USER_REPPARAMETER_COLUMN DBA_REPPRIORITY ALL_REPPRIORITY USER_REPPRIORITY DBA_REPPRIORITY_GROUP ALL_REPPRIORITY_GROUP USER_REPPRIORITY_GROUP DBA_REPPROP ALL_REPPROP USER_REPPROP DBA_REPRESOLUTION ALL_REPRESOLUTION USER_REPRESOLUTION RESOURCE_COST DBA_REPRESOLUTION_METHOD ALL_REPRESOLUTION_METHOD USER_REPRESOLUTION_METHOD DBA_REPRESOLUTION_STATISTICS ALL_REPRESOLUTION_STATISTICS USER_REPRESOLUTION_STATISTICS DBA_REPRESOL_STATS_CONTROL ALL_REPRESOL_STATS_CONTROL USER_REPRESOL_STATS_CONTROL DBA_REPSCHEMA ALL_REPSCHEMA USER_REPSCHEMA DBA_REPSITES ALL_REPSITES USER_REPSITES USER_RESOURCE_LIMITS DBA_RGROUP DBA_ROLES DBA_ROLE_PRIVS USER_ROLE_PRIVS ROLE_ROLE_PRIVS DBA_ROLLBACK_SEGS DBA_RSRC_CONSUMER_GROUPS DBA_RSRC_CONSUMER_GROUP_PRIVS USER_RSRC_CONSUMER_GROUP_PRIVS DBA_RSRC_MANAGER_SYSTEM_PRIVS USER_RSRC_MANAGER_SYSTEM_PRIVS DBA_RSRC_PLANS DBA_RSRC_PLAN_DIRECTIVES DBA_RULESETS USER_RULESETS s DBA_SEGMENTS USER_SEGMENTS SYS_DBA_SEGS SYS_USER_SEGS DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES SESSION_ROLES SESSION_PRIVS SESSION_CONTEXT DBA_SNAPSHOTS ALL_SNAPSHOTS USER_SNAPSHOTS DBA_SNAPSHOT_LOGS ALL_SNAPSHOT_LOGS USER_SNAPSHOT_LOGS DBA_SNAPSHOT_LOG_FILTER_COLS DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES DBA_SOURCE ALL_SOURCE USER_SOURCE DBA_STMT_AUDIT_OPTS DBA_SUBPART_COL_STATISTICS ALL_SUBPART_COL_STATISTICS USER_SUBPART_COL_STATISTICS DBA_SUBPART_HISTOGRAMS ALL_SUBPART_HISTOGRAMS USER_SUBPART_HISTOGRAMS DBA_SUBPART_KEY_COLUMNS ALL_SUBPART_KEY_COLUMNS USER_SUBPART_KEY_COLUMNS ALL_SUMDELTA DBA_SUMMARIES DBA_SYNONYMS ALL_SYNONYMS USER_SYNONYMS SYNONYMS PUBLICSYN DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS t DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES DBA_TABLES ALL_TABLES USER_TABLES TAB DBA_TABLESPACES USER_TABLESPACES DBA_TAB_COLUMNS ALL_TAB_COLUMNS USER_TAB_COLUMNS DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS DBA_TAB_HISTOGRAMS ALL_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS DBA_TAB_PARTITIONS ALL_TAB_PARTITIONS USER_TAB_PARTITIONS DBA_TAB_PRIVS ALL_TAB_PRIVS USER_TAB_PRIVS TABLE_PRIVILEGES ROLE_TAB_PRIVS ALL_TAB_PRIVS_MADE USER_TAB_PRIVS_MADE ALL_TAB_PRIVS_RECD USER_TAB_PRIVS_RECD TABQUOTAS DBA_TAB_SUBPARTITIONS ALL_TAB_SUBPARTITIONS USER_TAB_SUBPARTITIONS DBA_TEMP_FILES DBA_TRIGGERS ALL_TRIGGERS USER_TRIGGERS DBA_TRIGGER_COLS ALL_TRIGGER_COLS USER_TRIGGER_COLS DBA_TS_QUOTAS USER_TS_QUOTAS DBA_TYPES ALL_TYPES USER_TYPES DBA_TYPE_ATTRS ALL_TYPE_ATTRS USER_TYPE_ATTRS DBA_TYPE_METHODS ALL_TYPE_METHODS USER_TYPE_METHODS u DBA_UNUSED_COL_TABS ALL_UNUSED_COL_TABS USER_UNUSED_COL_TABS DBA_UPDATABLE_COLUMNS ALL_UPDATABLE_COLUMNS USER_UPDATABLE_COLUMNS DBA_USERS ALL_USERS USER_USERS DBA_USTATS ALL_USTATS USER_USTATS v DBA_VARRAYS ALL_VARRAYS USER_VARRAYS PRODUCT_COMPONENT_VERSION DBA_VIEWS ALL_VIEWS USER_VIEWS Other dictionary views below DEFCALL DEFCALLDEST DEFDEFAULTDEST DEFERRCOUNT DEFERROR DEFLOB DEFPROPAGATOR DEFSCHEDULE DEFTRAN DEFTRANDEST HS_ALL_CAPS HS_ALL_DD HS_ALL_INITS HS_BASE_CAPS HS_BASE_DD HS_CLASS_CAPS HS_CLASS_DD HS_CLASS_INIT HS_EXTERNAL_OBJECTS HS_EXTERNAL_OBJECT_PRIVILEGES HS_EXTERNAL_USER_PRIVILEGES HS_FDS_CLASS HS_FDS_INST HS_INST_CAPS HS_INST_DD HS_INST_INIT IMP7UEC IMP8CDT IMP8CDTU IMP8CON IMP8REPCAT IMP8TTD IMP8TTDU IMP8UEC JAVASNM LOADER_CONSTRAINT_INFO LOADER_FILE_TS LOADER_PARAM_INFO LOADER_PART_INFO LOADER_REF_INFO LOADER_TAB_INFO LOADER_TRIGGER_INFO ORA_KGLR7_DB_LINKS ORA_KGLR7_DEPENDENCIES ORA_KGLR7_IDL_CHAR ORA_KGLR7_IDL_SB4 ORA_KGLR7_IDL_UB1 ORA_KGLR7_IDL_UB2 ORA_KGLR7_OBJECTS ORDER_OBJECT_BY_DEPENDENCY PARSED_PIECES PARSED_SIZE PLUGGABLE_SET_CHECK PRODUCT_COMPONENT_VERSION PROXY_USERS PS1$ PSS1$ PUBLIC_DEPENDENCY REPCAT$_CDEF REPCAT_GENERATED REPCAT_REPCAT REPCAT_REPCATLOG REPCAT_REPOBJECT REPCAT_REPOBJECT_BASE REPCAT_REPPROP REPCAT_REPSCHEMA SM$AUDIT_CONFIG SM$TS_AVAIL SM$TS_FREE SM$TS_USED SM_$VERSION SOURCE_SIZE STRADDLING_RS_OBJECTS STRADDLING_TS_OBJECTS SYSSEGOBJ TRUSTED_SERVERS TSP$ TS_PITR_CHECK TS_PITR_INFO TS_PITR_OBJECTS_TO_BE_DROPPED TS_PLUG_INFO UNI_PLUGGABLE_SET_CHECK