Software >> Services >> RDBMS >> Oracle >>  9i >> What are the static data dictionary views

ALL_ALL_TABLES ALL_APPLY ALL_APPLY_CONFLICT_COLUMNS ALL_APPLY_DML_HANDLERS ALL_APPLY_ERROR ALL_APPLY_KEY_COLUMNS ALL_APPLY_PARAMETERS ALL_APPLY_PROGRESS ALL_ARGUMENTS ALL_ASSOCIATIONS ALL_AUDIT_POLICIES ALL_BASE_TABLE_MVIEWS ALL_CAPTURE ALL_CAPTURE_PARAMETERS ALL_CAPTURE_PREPARED_DATABASE ALL_CAPTURE_PREPARED_SCHEMAS ALL_CAPTURE_PREPARED_TABLES ALL_CATALOG ALL_CLUSTER_HASH_EXPRESSIONS ALL_CLUSTERS ALL_COL_COMMENTS ALL_COL_PRIVS ALL_COL_PRIVS_MADE ALL_COL_PRIVS_RECD ALL_COLL_TYPES ALL_CONS_COLUMNS ALL_CONS_OBJ_COLUMNS ALL_CONSTRAINTS ALL_CONTEXT ALL_DB_LINKS ALL_DEF_AUDIT_OPTS ALL_DEPENDENCIES ALL_DIM_ATTRIBUTES ALL_DIM_CHILD_OF ALL_DIM_HIERARCHIES ALL_DIM_JOIN_KEY ALL_DIM_LEVEL_KEY ALL_DIM_LEVELS ALL_DIMENSIONS ALL_DIRECTORIES ALL_ERRORS ALL_EVALUATION_CONTEXT_TABLES ALL_EVALUATION_CONTEXT_VARS ALL_EVALUATION_CONTEXTS ALL_EXTERNAL_LOCATIONS ALL_EXTERNAL_TABLES ALL_IND_COLUMNS ALL_IND_EXPRESSIONS ALL_IND_PARTITIONS ALL_IND_SUBPARTITIONS ALL_INDEXES ALL_INDEXTYPE_COMMENTS ALL_INDEXTYPE_OPERATORS ALL_INDEXTYPES ALL_INTERNAL_TRIGGERS ALL_JAVA_ARGUMENTS ALL_JAVA_CLASSES ALL_JAVA_DERIVATIONS ALL_JAVA_FIELDS ALL_JAVA_IMPLEMENTS ALL_JAVA_INNERS ALL_JAVA_LAYOUTS ALL_JAVA_METHODS ALL_JAVA_NCOMPS ALL_JAVA_RESOLVERS ALL_JAVA_THROWS ALL_JOBS ALL_JOIN_IND_COLUMNS ALL_LIBRARIES ALL_LOB_PARTITIONS ALL_LOB_SUBPARTITIONS ALL_LOB_TEMPLATES ALL_LOBS ALL_LOG_GROUP_COLUMNS ALL_LOG_GROUPS ALL_METHOD_PARAMS ALL_METHOD_RESULTS ALL_MVIEW_AGGREGATES ALL_MVIEW_ANALYSIS ALL_MVIEW_DETAIL_RELATIONS ALL_MVIEW_JOINS ALL_MVIEW_KEYS ALL_MVIEW_LOGS ALL_MVIEW_REFRESH_TIMES ALL_MVIEWS ALL_NESTED_TABLES ALL_OBJ_COLATTRS ALL_OBJECT_TABLES ALL_OBJECTS ALL_OPANCILLARY ALL_OPARGUMENTS ALL_OPBINDINGS ALL_OPERATOR_COMMENTS ALL_OPERATORS ALL_OUTLINE_HINTS ALL_OUTLINES ALL_PART_COL_STATISTICS ALL_PART_HISTOGRAMS ALL_PART_INDEXES ALL_PART_KEY_COLUMNS ALL_PART_LOBS ALL_PART_TABLES ALL_PARTIAL_DROP_TABS ALL_PENDING_CONV_TABLES ALL_POLICIES ALL_POLICY_CONTEXTS ALL_POLICY_GROUPS ALL_PROCEDURES ALL_PROPAGATION ALL_PUBLISHED_COLUMNS ALL_QUEUE_TABLES ALL_QUEUES ALL_REFRESH ALL_REFRESH_CHILDREN ALL_REFRESH_DEPENDENCIES ALL_REFS ALL_REGISTERED_MVIEWS ALL_REGISTRY_BANNERS ALL_RULE_SET_RULES ALL_RULE_SETS ALL_RULES ALL_SEQUENCES ALL_SOURCE ALL_SOURCE_TABLES ALL_SQLJ_TYPE_ATTRS ALL_SQLJ_TYPE_METHODS ALL_SQLJ_TYPES ALL_STORED_SETTINGS ALL_STREAMS_GLOBAL_RULES ALL_STREAMS_SCHEMA_RULES ALL_STREAMS_TABLE_RULES ALL_SUBPART_COL_STATISTICS ALL_SUBPART_HISTOGRAMS ALL_SUBPART_KEY_COLUMNS ALL_SUBPARTITION_TEMPLATES ALL_SUBSCRIBED_COLUMNS ALL_SUBSCRIBED_TABLES ALL_SUBSCRIPTIONS ALL_SUMDELTA ALL_SYNONYMS ALL_TAB_COL_STATISTICS ALL_TAB_COLUMNS ALL_TAB_COMMENTS ALL_TAB_HISTOGRAMS ALL_TAB_MODIFICATIONS ALL_TAB_PARTITIONS ALL_TAB_PRIVS ALL_TAB_PRIVS_MADE ALL_TAB_PRIVS_RECD ALL_TAB_SUBPARTITIONS ALL_TABLES ALL_TRIGGER_COLS ALL_TRIGGERS ALL_TYPE_ATTRS ALL_TYPE_METHODS ALL_TYPE_VERSIONS ALL_TYPES ALL_UNUSED_COL_TABS ALL_UPDATABLE_COLUMNS ALL_USERS ALL_USTATS ALL_VARRAYS ALL_VIEWS ALL_XML_SCHEMAS ALL_XML_TAB_COLS ALL_XML_TABLES ALL_XML_VIEW_COLS ALL_XML_VIEWS AUDIT_ACTIONS CATALOG CAT CHAINED_ROWS CHANGE_SOURCES CHANGE_SETS CHANGE_TABLES CLU CODE_PIECES CODE_SIZE COL COLS COLUMN_PRIVILEGES DATABASE_PROPERTIES DBA_2PC_NEIGHBORS DBA_2PC_PENDING DBA_ALL_TABLES DBA_APPLICATION_ROLES DBA_APPLY DBA_APPLY_CONFLICT_COLUMNS DBA_APPLY_DML_HANDLERS DBA_APPLY_ERROR DBA_APPLY_INSTANTIATED_OBJECTS DBA_APPLY_KEY_COLUMNS DBA_APPLY_PARAMETERS DBA_APPLY_PROGRESS DBA_AQ_AGENT_PRIVS DBA_AQ_AGENTS DBA_ASSOCIATIONS DBA_ATTRIBUTE_TRANSFORMATIONS DBA_AUDIT_EXISTS DBA_AUDIT_OBJECT DBA_AUDIT_POLICIES DBA_AUDIT_SESSION DBA_AUDIT_STATEMENT DBA_AUDIT_TRAIL DBA_AW_PS DBA_AWS DBA_BASE_TABLE_MVIEWS DBA_BLOCKERS DBA_CAPTURE DBA_CAPTURE_PARAMETERS DBA_CAPTURE_PREPARED_DATABASE DBA_CAPTURE_PREPARED_SCHEMAS DBA_CAPTURE_PREPARED_TABLES DBA_CATALOG DBA_CLU_COLUMNS DBA_CLUSTER_HASH_EXPRESSIONS DBA_CLUSTERS DBA_COL_COMMENTS DBA_COL_PRIVS DBA_COLL_TYPES DBA_CONS_COLUMNS DBA_CONS_OBJ_COLUMNS DBA_CONSTRAINTS DBA_CONTEXT DBA_DATA_FILES DBA_DB_LINKS DBA_DDL_LOCKS DBA_DEPENDENCIES DBA_DIM_ATTRIBUTES DBA_DIM_CHILD_OF DBA_DIM_HIERARCHIES DBA_DIM_JOIN_KEY DBA_DIM_LEVEL_KEY DBA_DIM_LEVELS DBA_DIMENSIONS DBA_DIRECTORIES DBA_DML_LOCKS DBA_DMT_FREE_SPACE DBA_DMT_USED_EXTENTS DBA_ERRORS DBA_EVALUATION_CONTEXT_TABLES DBA_EVALUATION_CONTEXT_VARS DBA_EVALUATION_CONTEXTS DBA_EXP_FILES DBA_EXP_OBJECTS DBA_EXP_VERSION DBA_EXTENTS DBA_EXTERNAL_LOCATIONS DBA_EXTERNAL_TABLES DBA_FGA_AUDIT_TRAIL DBA_FREE_SPACE DBA_FREE_SPACE_COALESCED DBA_IND_COLUMNS DBA_IND_EXPRESSIONS DBA_IND_PARTITIONS DBA_IND_SUBPARTITIONS DBA_INDEXES DBA_INDEXTYPE_COMMENTS DBA_INDEXTYPE_OPERATORS DBA_INDEXTYPES DBA_INTERNAL_TRIGGERS DBA_JAVA_ARGUMENTS DBA_JAVA_CLASSES DBA_JAVA_DERIVATIONS DBA_JAVA_FIELDS DBA_JAVA_IMPLEMENTS DBA_JAVA_INNERS DBA_JAVA_LAYOUTS DBA_JAVA_METHODS DBA_JAVA_NCOMPS DBA_JAVA_POLICY DBA_JAVA_RESOLVERS DBA_JAVA_THROWS DBA_JOBS DBA_JOBS_RUNNING DBA_JOIN_IND_COLUMNS DBA_KGLLOCK DBA_LIBRARIES DBA_LMT_FREE_SPACE DBA_LMT_USED_EXTENTS DBA_LOB_PARTITIONS DBA_LOB_SUBPARTITIONS DBA_LOB_TEMPLATES DBA_LOBS DBA_LOCK DBA_LOCK_INTERNAL DBA_LOCKS DBA_LOG_GROUP_COLUMNS DBA_LOG_GROUPS DBA_LOGSTDBY_EVENTS DBA_LOGSTDBY_LOG DBA_LOGSTDBY_NOT_UNIQUE DBA_LOGSTDBY_PARAMETERS DBA_LOGSTDBY_PROGRESS DBA_LOGSTDBY_SKIP DBA_LOGSTDBY_SKIP_TRANSACTION DBA_LOGSTDBY_UNSUPPORTED DBA_METHOD_PARAMS DBA_METHOD_RESULTS DBA_MVIEW_AGGREGATES DBA_MVIEW_ANALYSIS DBA_MVIEW_DETAIL_RELATIONS DBA_MVIEW_JOINS DBA_MVIEW_KEYS DBA_MVIEW_LOG_FILTER_COLS DBA_MVIEW_LOGS DBA_MVIEW_REFRESH_TIMES DBA_MVIEWS DBA_NESTED_TABLES DBA_OBJ_AUDIT_OPTS DBA_OBJ_COLATTRS DBA_OBJECT_SIZE DBA_OBJECT_TABLES DBA_OBJECTS DBA_OPANCILLARY DBA_OPARGUMENTS DBA_OPBINDINGS DBA_OPERATOR_COMMENTS DBA_OPERATORS DBA_ORPHAN_KEY_TABLE DBA_OUTLINE_HINTS DBA_OUTLINES DBA_PART_COL_STATISTICS DBA_PART_HISTOGRAMS DBA_PART_INDEXES DBA_PART_KEY_COLUMNS DBA_PART_LOBS DBA_PART_TABLES DBA_PARTIAL_DROP_TABS DBA_PENDING_CONV_TABLES DBA_PENDING_TRANSACTIONS DBA_POLICIES DBA_POLICY_CONTEXTS DBA_POLICY_GROUPS DBA_PRIV_AUDIT_OPTS DBA_PROCEDURES DBA_PROFILES DBA_PROPAGATION DBA_PROXIES DBA_PUBLISHED_COLUMNS DBA_QUEUE_SCHEDULES DBA_QUEUE_TABLES DBA_QUEUES DBA_RCHILD DBA_REFRESH DBA_REFRESH_CHILDREN DBA_REFS DBA_REGISTERED_MVIEW_GROUPS DBA_REGISTERED_MVIEWS DBA_REGISTRY DBA_REGISTRY_HIERARCHY DBA_REPAIR_TABLE DBA_RESUMABLE DBA_RGROUP DBA_ROLE_PRIVS DBA_ROLES DBA_ROLLBACK_SEGS DBA_RSRC_CONSUMER_GROUP_PRIVS DBA_RSRC_CONSUMER_GROUPS DBA_RSRC_MANAGER_SYSTEM_PRIVS DBA_RSRC_PLAN_DIRECTIVES DBA_RSRC_PLANS DBA_RULE_SET_RULES DBA_RULE_SETS DBA_RULES DBA_SEGMENTS DBA_SEQUENCES DBA_SOURCE DBA_SOURCE_TABLES DBA_SQLJ_TYPE_ATTRS DBA_SQLJ_TYPE_METHODS DBA_SQLJ_TYPES DBA_STMT_AUDIT_OPTS DBA_STORED_SETTINGS DBA_STREAMS_GLOBAL_RULES DBA_STREAMS_SCHEMA_RULES DBA_STREAMS_TABLE_RULES DBA_SUBPART_COL_STATISTICS DBA_SUBPART_HISTOGRAMS DBA_SUBPART_KEY_COLUMNS DBA_SUBPARTITION_TEMPLATES DBA_SUBSCRIBED_COLUMNS DBA_SUBSCRIBED_TABLES DBA_SUBSCRIPTIONS DBA_SYNONYMS DBA_SYS_PRIVS DBA_TAB_COL_STATISTICS DBA_TAB_COLUMNS DBA_TAB_COMMENTS DBA_TAB_HISTOGRAMS DBA_TAB_MODIFICATIONS DBA_TAB_PARTITIONS DBA_TAB_PRIVS DBA_TAB_SUBPARTITIONS DBA_TABLES DBA_TABLESPACES DBA_TEMP_FILES DBA_TRANSFORMATIONS DBA_TRIGGER_COLS DBA_TRIGGERS DBA_TS_QUOTAS DBA_TYPE_ATTRS DBA_TYPE_METHODS DBA_TYPE_VERSIONS DBA_TYPES DBA_UNDO_EXTENTS DBA_UNUSED_COL_TABS DBA_UPDATABLE_COLUMNS DBA_USERS DBA_USTATS DBA_VARRAYS DBA_VIEWS DBA_WAITERS DBA_XML_SCHEMAS DBA_XML_TAB_COLS DBA_XML_TABLES DBA_XML_VIEW_COLS DBA_XML_VIEWS DBMS_ALERT_INFO DBMS_LOCK_ALLOCATED DEPTREE DICT DICT_COLUMNS DICTIONARY ERROR_SIZE EXCEPTIONS FILE_LOCK FILE_PING FILEXT$ GLOBAL_NAME 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_OBJECT_PRIVILEGES HS_EXTERNAL_OBJECTS HS_EXTERNAL_USER_PRIVILEGES HS_FDS_CLASS HS_FDS_INST HS_INST_CAPS HS_INST_DD HS_INST_INIT IDEPTREE IND INDEX_HISTOGRAM INDEX_STATS MAP_OBJECT NLS_DATABASE_PARAMETERS NLS_INSTANCE_PARAMETERS NLS_SESSION_PARAMETERS OBJ PARSED_PIECES PARSED_SIZE PLAN_TABLE PLUGGABLE_SET_CHECK PRODUCT_COMPONENT_VERSION PROXY_USERS PSTUBTBL PUBLIC_DEPENDENCY PUBLICSYN QUEUE_PRIVILEGES RESOURCE_COST RESOURCE_MAP ROLE_ROLE_PRIVS ROLE_SYS_PRIVS ROLE_TAB_PRIVS SEQ SESSION_CONTEXT SESSION_PRIVS SESSION_ROLES SOURCE_SIZE STMT_AUDIT_OPTION_MAP SYN SYSCATALOG SYSFILES SYSSEGOBJ SYSTEM_PRIVILEGE_MAP SYS_OBJECTS TAB TABLE_PRIVILEGE_MAP TABLE_PRIVILEGES TABS TABQUOTAS TRUSTED_SERVERS TS_PITR_CHECK TS_PITR_OBJECTS_TO_BE_DROPPED UNI_PLUGGABLE_SET_CHECK USER_ALL_TABLES USER_AQ_AGENT_PRIVS USER_ARGUMENTS USER_ASSOCIATIONS USER_ATTRIBUTE_TRANSFORMATIONS USER_AUDIT_OBJECT USER_AUDIT_POLICIES USER_AUDIT_SESSION USER_AUDIT_STATEMENT USER_AUDIT_TRAIL USER_AW_PS USER_AWS USER_BASE_TABLE_MVIEWS USER_CATALOG USER_CLU_COLUMNS USER_CLUSTER_HASH_EXPRESSIONS USER_CLUSTERS USER_COL_COMMENTS USER_COL_PRIVS USER_COL_PRIVS_MADE USER_COL_PRIVS_RECD USER_COLL_TYPES USER_CONS_COLUMNS USER_CONS_OBJ_COLUMNS USER_CONSTRAINTS USER_DB_LINKS USER_DEPENDENCIES USER_DIM_ATTRIBUTES USER_DIM_CHILD_OF USER_DIM_HIERARCHIES USER_DIM_JOIN_KEY USER_DIM_LEVEL_KEY USER_DIM_LEVELS USER_DIMENSIONS USER_ERRORS USER_EVALUATION_CONTEXT_TABLES USER_EVALUATION_CONTEXT_VARS USER_EVALUATION_CONTEXTS USER_EXTENTS USER_EXTERNAL_LOCATIONS USER_EXTERNAL_TABLES USER_FREE_SPACE USER_IND_COLUMNS USER_IND_EXPRESSIONS USER_IND_PARTITIONS USER_IND_SUBPARTITIONS USER_INDEXES USER_INDEXTYPE_COMMENTS USER_INDEXTYPE_OPERATORS USER_INDEXTYPES USER_INTERNAL_TRIGGERS USER_JAVA_ARGUMENTS USER_JAVA_CLASSES USER_JAVA_DERIVATIONS USER_JAVA_FIELDS USER_JAVA_IMPLEMENTS USER_JAVA_INNERS USER_JAVA_LAYOUTS USER_JAVA_METHODS USER_JAVA_NCOMPS USER_JAVA_POLICY USER_JAVA_RESOLVERS USER_JAVA_THROWS USER_JOBS USER_JOIN_IND_COLUMNS USER_LIBRARIES USER_LOB_PARTITIONS USER_LOB_SUBPARTITIONS USER_LOB_TEMPLATES USER_LOBS USER_LOG_GROUP_COLUMNS USER_LOG_GROUPS USER_METHOD_PARAMS USER_METHOD_RESULTS USER_MVIEW_AGGREGATES USER_MVIEW_ANALYSIS USER_MVIEW_DETAIL_RELATIONS USER_MVIEW_JOINS USER_MVIEW_KEYS USER_MVIEW_LOGS USER_MVIEW_REFRESH_TIMES USER_MVIEWS USER_NESTED_TABLES USER_OBJ_AUDIT_OPTS USER_OBJ_COLATTRS USER_OBJECT_SIZE USER_OBJECT_TABLES USER_OBJECTS USER_OPANCILLARY USER_OPARGUMENTS USER_OPBINDINGS USER_OPERATOR_COMMENTS USER_OPERATORS USER_OUTLINE_HINTS USER_OUTLINES USER_PART_COL_STATISTICS USER_PART_HISTOGRAMS USER_PART_INDEXES USER_PART_KEY_COLUMNS USER_PART_LOBS USER_PART_TABLES USER_PARTIAL_DROP_TABS USER_PASSWORD_LIMITS USER_PENDING_CONV_TABLES USER_POLICIES USER_POLICY_CONTEXTS USER_POLICY_GROUPS USER_PROCEDURES USER_PROXIES USER_PUBLISHED_COLUMNS USER_QUEUE_SCHEDULES USER_QUEUE_TABLES USER_QUEUES USER_REFRESH USER_REFRESH_CHILDREN USER_REFS USER_REGISTERED_MVIEWS USER_REGISTRY USER_RESOURCE_LIMITS USER_RESUMABLE USER_ROLE_PRIVS USER_RSRC_CONSUMER_GROUP_PRIVS USER_RSRC_MANAGER_SYSTEM_PRIVS USER_RULE_SET_RULES USER_RULE_SETS USER_RULES USER_SEGMENTS USER_SEQUENCES USER_SOURCE USER_SOURCE_TABLES USER_SQLJ_TYPE_ATTRS USER_SQLJ_TYPE_METHODS USER_SQLJ_TYPES USER_STORED_SETTINGS USER_SUBPART_COL_STATISTICS USER_SUBPART_HISTOGRAMS USER_SUBPART_KEY_COLUMNS USER_SUBPARTITION_TEMPLATES USER_SUBSCRIBED_COLUMNS USER_SUBSCRIBED_TABLES USER_SUBSCRIPTIONS USER_SYNONYMS USER_SYS_PRIVS USER_TAB_COL_STATISTICS USER_TAB_COLUMNS USER_TAB_COMMENTS USER_TAB_HISTOGRAMS USER_TAB_MODIFICATIONS USER_TAB_PARTITIONS USER_TAB_PRIVS USER_TAB_PRIVS_MADE USER_TAB_PRIVS_RECD USER_TAB_SUBPARTITIONS USER_TABLES USER_TABLESPACES USER_TRANSFORMATIONS USER_TRIGGER_COLS USER_TRIGGERS USER_TS_QUOTAS USER_TYPE_ATTRS USER_TYPE_METHODS USER_TYPE_VERSIONS USER_TYPES USER_UNUSED_COL_TABS USER_UPDATABLE_COLUMNS USER_USERS USER_USTATS USER_VARRAYS USER_VIEWS USER_XML_SCHEMAS USER_XML_TAB_COLS USER_XML_TABLES USER_XML_VIEW_COLS USER_XML_VIEWS