没有合适的资源?快使用搜索试试~ 我知道了~
本文介绍了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 tables, views, synonyms, sequences accessible to the
user
ALL_COL_COMMENTS Comments on columns of accessible tables and views
ALL_COL_GRANTS_MAD
E
Grants on columns for which the user is owner or grantor
ALL_COL_GRANTS_REC
D
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 de*nitions on accessible tables
ALL_CONS_COLUMNS Information about accessible columns in constraint
de*nitions
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_CHILDRE
N
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_MAD
E
User's grants and grants on user's objects
ALL_TAB_GRANTS_REC
D
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/logo9s
USER_AUDIT_OBJECT Audit trail records for statements concerning objects,
speci*cally: table, cluster, view, index, sequence,
[public] database link, [public] synonym, procedure,
trigger, rollback segment, tablespace, role, user
USER_AUDIT_SESSION
USER_AUDIT_STATEME
NT
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_MA
DE
All grants on columns of objects owned by the user
USER_COL_GRANTS_RE
CD
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_MAD
E
All grants on columns of objects owned by the user
USER_COL_PRIVS_RECDGrants on columns for which the user is the grantee
USER_CONSTRAINTS Constraint de*nitions on user's own tables
USER_CONS_COLUMNS Information about accessible columns in constraint
de*nitions
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_CHILD
REN
All the objects in refresh groups, where the user owns
the refresh group
USER_RESOURCE_LIMIT
S
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_MA
DE
All grants on objects owned by the user
USER_TAB_GRANTS_RE
CD
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_MADEAll 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
剩余21页未读,继续阅读
资源评论
luib88
- 粉丝: 0
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功