| 网站首页 | 资讯 | Hack | 漏洞 | 网管 | 编程 | 培训 | 品黑页 | 软件 | 论坛 | 动画 | 视频 | 经典 | 教学站 | 黑客点睛 | 
服务导航 我要发布 主力频道 空间域名 精华收集 服务器出租 黑客培训 光盘刻录 特色服务 解决方案 我要投诉
您现在的位置: 华夏黑客同盟 >> 培训 >> 认证考核 >> Oracle认证 >> 正文 用户登录 新用户注册
介绍了Oracle常用数据字典           ★★★ 【字体:
介绍了Oracle常用数据字典
作者:华盟收集 文章来源:本站原创 点击数: 更新时间:2008-5-4
以下表格中收集了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_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 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 Synonym for ALL_TAB_COLUMNS  
ALL_COL_GRANTS Synonym for COLUMN_PRIVILEGES  
ALL_JOBS Synonym for USER_JOBS  
ALL_TAB_GRANTS Synonym for TABLE_PRIVILEGES  
CAT Synonym for USER_CATALOG  
CLU Synonym for USER_CLUSTERS  
COLS Synonym for USER_TAB_COLUMNS  
DBA_AUDIT_CONNECT Synonym for USER_AUDIT_CONNECT  
DBA_AUDIT_RESOURCE Synonym for USER_AUDIT_RESOURCE  
DBA_REFRESH_CHILDREN Synonym for USER_REFRESH_CHILDREN  
DICT Synonym for DICTIONARY  
IND Synonym for USER_INDEXES  
OBJ Synonym for USER_OBJECTS  
SEQ Synonym for USER_SEQUENCES  
SM$VERSION Synonym for SM_$VERSION  
SYN Synonym for USER_SYNONYMS  
TABS Synonym for USER_TABLES  
V$ACCESS Synonym for V_$ACCESS  
V$ARCHIVE Synonym for V_$ARCHIVE  
V$BACKUP Synonym for V_$BACKUP  
V$BGPROCESS Synonym for V_$BGPROCESS  
V$CIRCUIT Synonym for V_$CIRCUIT  
V$COMPATIBILITY Synonym for V_$COMPATIBILITY  
V$COMPATSEG Synonym for V_$COMPATSEG  
V$CONTROLFILE Synonym for V_$CONTROLFILE  
V$DATABASE Synonym for V_$DATABASE  
V$DATAFILE Synonym for V_$DATAFILE  
V$DBFILE Synonym for V_$DBFILE  
V$DBLINK Synonym for V_$DBLINK  
V$DB_OBJECT_CACHE Synonym for V_$DB_OBJECT_CACHE  
V$DISPATCHER Synonym for V_$DISPATCHER  
V$ENABLEDPRIVS Synonym for V_$ENABLEDPRIVS  
V$FILESTAT Synonym for V_$FILESTAT  
V$FIXED_TABLE Synonym for V_$FIXED_TABLE  
V$LATCH Synonym for V_$LATCH  
V$LATCHHOLDER Synonym for V_$LATCHHOLDER  
V$LATCHNAME Synonym for V_$LATCHNAME  
V$LIBRARYCACHE Synonym for V_$LIBRARYCACHE  
V$LICENSE Synonym for V_$LICENSE  
V$LOADCSTAT Synonym for V_$LOADCSTAT  
V$LOADTSTAT Synonym for V_$LOADTSTAT  
V$LOCK Synonym for V_$LOCK  
V$LOG Synonym for V_$LOG  
V$LOGFILE Synonym for V_$LOGFILE  
V$LOGHIST Synonym for V_$LOGHIST  
V$LOG_HISTORY Synonym for V_$LOG_HISTORY  
V$MLS_PARAMETERS Synonym for V_$MLS_PARAMETERS  
V$MTS Synonym for V_$MTS  
V$NLS_PARAMETERS Synonym for V_$NLS_PARAMETERS  
V$NLS_VALID_VALUES Synonym for V_$NLS_VALID_VALUES  
V$OPEN_CURSOR Synonym for V_$OPEN_CURSOR  
V$OPTION Synonym for V_$OPTION  
V$PARAMETER Synonym for V_$PARAMETER  
V$PQ_SESSTAT Synonym for V_$PQ_SESSTAT  
V$PQ_SLAVE Synonym for V_$PQ_SLAVE  
V$PQ_SYSSTAT Synonym for V_$PQ_SYSSTAT  
V$PROCESS Synonym for V_$PROCESS  
V$QUEUE Synonym for V_$QUEUE  
V$RECOVERY_LOG Synonym for V_$RECOVERY_LOG  
V$RECOVER_FILE Synonym for V_$RECOVER_FILE  
V$REQDIST Synonym for V_$REQDIST  
V$RESOURCE Synonym for V_$RESOURCE  
V$ROLLNAME Synonym for V_$ROLLNAME  
V$ROLLSTAT Synonym for V_$ROLLSTAT  
V$ROWCACHE Synonym for V_$ROWCACHE  
V$SESSION Synonym for V_$SESSION  
V$SESSION_CURSOR_CACHE Synonym for V_$SESSION_CURSOR_CACHE  
V$SESSION_EVENT Synonym for V_$SESSION_EVENT  
V$SESSION_WAIT Synonym for V_$SESSION_WAIT  
V$SESSTAT Synonym for V_$SESSTAT  
V$SESS_IO Synonym for V_$SESS_IO  
V$SGA Synonym for V_$SGA  
V$SGASTAT Synonym for V_$SGASTAT  
V$SHARED_SERVER Synonym for V_$SHARED_SERVER  
V$SQLAREA Synonym for V_$SQLAREA  
V$STATNAME Synonym for V_$STATNAME  
V$SYSSTAT Synonym for V_$SYSSTAT  
V$SYSTEM_CURSOR_CACHE Synonym for V_$SYSTEM_CURSOR_CACHE  
V$SYSTEM_EVENT Synonym for V_$SYSTEM_EVENT  
V$THREAD Synonym for V_$THREAD  
V$TIMER Synonym for V_$TIMER  
V$TRANSACTION Synonym for V_$TRANSACTION  
V$TYPE_SIZE Synonym for V_$TYPE_SIZE  
V$VERSION Synonym for V_$VERSION  
V$WAITSTAT Synonym for V_$WAITSTAT  
V$_LOCK Synonym for V_$_LOCK
责任编辑:章新艳  联系方式  Email:章新艳
电话:51228163
  • 上一篇培训:

  • 下一篇培训:
  • (只显示最新5条。评论内容只代表网友观点,与本站立场无关!)
    姓 名:
    * 游客填写  ·注册用户
    主 页:
    评 分:
    1分 2分 3分 4分 5分
    评论内容:
    验证码: *
  • 请遵守《互联网电子公告服务管理规定》及中华人民共和国其他各项有关法律法规。
  • 严禁发表危害国家安全、损害国家利益、破坏民族团结、破坏国家宗教政策、破坏社会稳定、侮辱、诽谤、教唆、淫秽等内容的评论 。
  • 用户需对自己在使用本站服务过程中的行为承担法律责任(直接或间接导致的)。
  • 本站管理员有权保留或删除评论内容。
  • 评论内容只代表网友个人观点,与本网站立场无关。
  • 最新hack更新
    最新推荐资讯
    相关培训
    Oracle10g数据库的创建
    ORACLE常见问题诊断方法
    Oracle Warehouse Builder11g
    优化调整Oracle8i数据库系统
    将Oracle汉字转换为拼音
    Ruby脚本调用Oracle存储
    Oracle游标使用大全二
    Oracle游标使用大全一
    Oracle DBA数据库试题精选
    VI的常见使用技巧
    最新会员软件
    最新推荐视频
    最新推荐动画

    Copyright @ 2005 77169.Net Inc. All rights reserved. 华夏黑客同盟 版权所有
    北京市电信通提供网络带宽

    mailto:webmaster@77169.net
    咨询QQ号:836982 / 59280880
    联系站长 QQ38588913
    热线电话: 86-10-67634029/676229433
    京ICP证041431号