Oracle常用数据字典.docx

以下表格中收集了 Oracle 数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用‘Describ语e’句来查询。 命名说明： Oracle 数据字典中，对象名称多数以USER.，ALL.，DBA.为前缀USER.视图中记录通常记录执行查询的帐户所拥有的对象的信息，ALL.视图中记录包括USER记录和授权至 PUBLIC 或用户的对象的信息，DBA.视图包含所有数据库对象，而不管其所有者。 使用举例： select * from dba_data_files 查询表空间的信息(当前用户必须拥有 DBA 角色)。select owner , object_name ,object_type from all_objects 查询某一用户下的所有表、过程、函数等信息。 视图名 ALL_CATALOG ALL_COL_COMMENTS ALL_COL_GRANTS_MADE ALL_COL_GRANTS_RECD 描述 All tables, views, synonyms, sequences accessible to the user Comments on columns of accessible tables and views Grants on columns for which the user is owner or grantor Grants on columns for which the user or PUBLIC is the grantee 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 ALL_COL_PRIVS_RECD ALL_CONSTRAINTS ALL_CONS_COLUMNS ALL_DB_LINKS ALL_DEF_AUDIT_OPTS ALL_DEPENDENCIES ALL_ERRORS ALL_INDEXES ALL_IND_COLUMNS ALL_OBJECTS ALL_REFRESH Grants on columns for which the user is owner or grantor Grants on columns for which the user, PUBLIC or enabled role is the grantee Constraint definitions on accessible tables Information about accessible columns in constraint definitions Database links accessible to the user Auditing options for newly created objects Dependencies to and from objects accessible to the user Current errors on stored objects that user is allowed to create Descriptions of indexes on tables accessible to the user COLUMNs comprising INDEXes on accessible TABLES Objects accessible to the user 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_SEQUENCES ALL_SNAPSHOTS ALL_SOURCE ALL_SYNONYMS ALL_TABLES ALL_TAB_COLUMNS ALL_TAB_COMMENTS ALL_TAB_GRANTS_MADE ALL_TAB_GRANTS_RECD Description of SEQUENCEs accessible to the user Snapshots the user can look at Current source on stored objects that user is allowed to create All synonyms accessible to the user Descri