Oracle常用数据字典
--------------------------------------------------------------------
命名说明： Oracle数据字典中，对象名称多数以"USER."，"ALL."，"DBA."为前缀"USER."视图中记录通常记录执行查询的帐户所拥有的对象的信息，"ALL."视图中记录包括"USER"记录和授权至PUBLIC或用户的对象的信息，"DBA."视图包含所有数据库对象，而不管其所有者。
使用举例： select * from dba_data_files
查询表空间的信息(当前用户必须拥有DBA角色)。 select owner , object_name ,object_type from all_objects 查询某一用户下的所有表、过程、函数等信息。
说明 以下表格中收集了Oracle数据字典中几乎所有的视图或别名，
至于每个视图或别名的字段请用‘Describe’语句来查询。
[@more@]视图名 | 描述 |
ALL_CATALOG | All tables, views, synonyms, sequences accessible to the user |
ALL_COL_COMMENTS | Comments on columns of accessible tables and views |
ALL_COL_GRANTS_MADE | Grants on columns for which the user is owner or grantor |
ALL_COL_GRANTS_RECD | 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 | Grants on columns for which the user is owner or grantor |
ALL_COL_PRIVS_RECD | Grants on columns for which the user, PUBLIC or enabled role is the grantee |
ALL_CONSTRAINTS | Constraint definitions on accessible tables |
ALL_CONS_COLUMNS | Information about accessible columns in constraint definitions |
ALL_DB_LINKS | Database links accessible to the user |
ALL_DEF_AUDIT_OPTS | Auditing options for newly created objects |
ALL_DEPENDENCIES | Dependencies to and from objects accessible to the user |
ALL_ERRORS | Current errors on stored objects that user is allowed to create |
ALL_INDEXES | Descriptions of indexes on tables accessible to the user |
ALL_IND_COLUMNS | COLUMNs comprising INDEXes on accessible TABLES |
ALL_OBJECTS | Objects accessible to the user |
ALL_REFRESH | 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 | Description of SEQUENCEs accessible to the user |
ALL_SNAPSHOTS | Snapshots the user can look at |
ALL_SOURCE | Current source on stored objects that user is allowed to create |
ALL_SYNONYMS | All synonyms accessible to the user |
ALL_TABLES | Description of tables accessible to the user |
ALL_TAB_COLUMNS | Columns of all tables, views and clusters |
ALL_TAB_COMMENTS | Comments on tables and views accessible to the user |
ALL_TAB_GRANTS_MADE | User's grants and grants on user's objects |
ALL_TAB_GRANTS_RECD | Grants on objects for which the user or PUBLIC is the grantee |
ALL_TAB_PRIVS | Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
ALL_TAB_PRIVS_MADE | User's grants and grants on user's objects |
ALL_TAB_PRIVS_RECD | Grants on objects for which the user, PUBLIC or enabled role is the grantee |
ALL_TRIGGERS | Triggers accessible to the current user |
ALL_TRIGGER_COLS | Column usage in user's triggers or in triggers on user's tables |
ALL_USERS | Information about all users of the database |
ALL_VIEWS | Text of views accessible to the user |
USER_AUDIT_CONNECT | Audit trail entries for user logons/logoffs |
USER_AUDIT_OBJECT | Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user |
USER_AUDIT_SESSION |
|
USER_AUDIT_STATEMENT | Audit trail records concerning grant, revoke, audit, noaudit and alter system |
USER_AUDIT_TRAIL | Audit trail entries relevant to the user |
USER_CATALOG | Tables, Views, Synonyms and Sequences owned by the user |
USER_CLUSTERS | Descriptions of user's own clusters |
USER_CLU_COLUMNS | Mapping of table columns to cluster columns |
USER_COL_COMMENTS | Comments on columns of user's tables and views |
USER_COL_GRANTS | Grants on columns for which the user is the owner, grantor or grantee |
USER_COL_GRANTS_MADE | All grants on columns of objects owned by the user |
USER_COL_GRANTS_RECD | Grants on columns for which the user is the grantee |
USER_COL_PRIVS | Grants on columns for which the user is the owner, grantor or grantee |
USER_COL_PRIVS_MADE | All grants on columns of objects owned by the user |
USER_COL_PRIVS_RECD | Grants on columns for which the user is the grantee |
USER_CONSTRAINTS | Constraint definitions on user's own tables |
USER_CONS_COLUMNS | Information about accessible columns in constraint definitions |
USER_CROSS_REFS | Cross references for user's views and synonyms |
USER_DB_LINKS | Database links owned by the user |
USER_DEPENDENCIES | Dependencies to and from a users objects |
USER_ERRORS | Current errors on stored objects owned by the user |
USER_EXTENTS | Extents comprising segments owned by the user |
USER_FREE_SPACE | Free extents in tablespaces accessible to the user |
USER_INDEXES | Description of the user's own indexes |
USER_IND_COLUMNS | COLUMNs comprising user's INDEXes or on user's TABLES |
USER_JOBS | All jobs owned by this user |
USER_OBJECTS | Objects owned by the user |
USER_OBJECT_SIZE | Sizes, in bytes, of various pl/sql objects |
USER_OBJ_AUDIT_OPTS | Auditing options for user's own tables and views |
USER_REFRESH | All the refresh groups |
USER_REFRESH_CHILDREN | All the objects in refresh groups, where the user owns the refresh group |
USER_RESOURCE_LIMITS | Display resource limit of the user |
USER_ROLE_PRIVS |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7830804/viewspace-863115/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
[参考]PDM/PLM用户需求问卷
下一篇：
Oracle字符集问题总结
请登录后发表评论
登录
全部评论
北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区 广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员 违法和不良信息举报电话:18101376593 |
