Oracle数据字典 |
| 发布： 2007-06-06 18:43 |
|
Oracle数据字典 以下表格中收集了Oracle数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用‘Describe’语句来查询。 命名说明： 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 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 当前用户可访问的表的索引的描述 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 Roles granted to current user USER_SEGMENTS Storage allocated for all database segments USER_SEQUENCES Description of the user's own SEQUENCEs USER_SNAPSHOTS Snapshots the user can look at USER_SNAPSHOT_LOGS All snapshot logs owned by the user USER_SOURCE Source of stored objects accessible to the user USER_SYNONYMS The user's private synonyms USER_SYS_PRIVS System privileges granted to current user USER_TABLES Description of the user's own tables USER_TABLESPACES Description of accessible tablespaces USER_TAB_AUDIT_OPTS Auditing options for user's own tables and views USER_TAB_COLUMNS Columns of user's tables, views and clusters USER_TAB_COMMENTS Comments on the tables and views owned by the user USER_TAB_GRANTS Grants on objects for which the user is the owner, grantor or grantee USER_TAB_GRANTS_MADE All grants on objects owned by the user USER_TAB_GRANTS_RECD Grants on objects for which the user is the grantee USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee USER_TAB_PRIVS_MADE All grants on objects owned by the user USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee USER_TRIGGERS Triggers owned by the user USER_TRIGGER_COLS Column usage in user's triggers USER_TS_QUOTAS Tablespace quotas for the user USER_USERS Information about the current user USER_VIEWS Text of views owned by the user AUDIT_ACTIONS Description table for audit trail action type codes. Maps action type numbers to action type names COLUMN_PRIVILEGES Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee DICTIONARY Description of data dictionary tables and views DICT_COLUMNS Description of columns in data dictionary tables and views DUAL GLOBAL_NAME global database name INDEX_HISTOGRAM statistics on keys with repeat count INDEX_STATS statistics on the b-tree RESOURCE_COST Cost for each resource ROLE_ROLE_PRIVS Roles which are granted to roles ROLE_SYS_PRIVS System privileges granted to roles ROLE_TAB_PRIVS Table privileges granted to roles SESSION_PRIVS Privileges which the user currently has set SESSION_ROLES Roles which the user currently has enabled. TABLE_PRIVILEGES Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee ACCESSIBLE_COLUMNS |
|
原文： http://qtchina.tk/?q=node/57 |
|
Powered by zexport
|
