分享
 
 
 

Oracle常用数据字典

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

作者:佚名 来源:InterNet 加入时间:2003-7-20

以下表格中收集了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_CATALOGAll tables, views, synonyms, sequences Accessible to the user ALL_COL_COMMENTSComments on columns of accessible tables and views ALL_COL_GRANTS_MADEGrants on columns for which the user is owner or grantorALL_COL_GRANTS_RECDGrants on columns for which the user or PUBLIC is the grantee ALL_COL_PRIVSGrants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee ALL_COL_PRIVS_MADEGrants on columns for which the user is owner or grantorALL_COL_PRIVS_RECDGrants on columns for which the user, PUBLIC or enabled role is the grantee ALL_CONSTRAINTSConstraint definitions on accessible tables ALL_CONS_COLUMNSInformation about accessible columns in constraint definitions ALL_DB_LINKSDatabase links accessible to the user ALL_DEF_AUDIT_OPTSAuditing options for newly created objects ALL_DEPENDENCIESDependencies to and from objects accessible to the user ALL_ERRORSCurrent errors on stored objects that user is allowed to create ALL_INDEXESDescriptions of indexes on tables accessible to the user ALL_IND_COLUMNSCOLUMNs comprising INDEXes on accessible TABLES ALL_OBJECTSObjects accessible to the user ALL_REFRESHAll the refresh groups that the user can toUCh ALL_REFRESH_CHILDRENAll the objects in refresh groups, where the user can touch the group ALL_SEQUENCESDescription of SEQUENCEs accessible to the user ALL_SNAPSHOTSSnapshots the user can look at ALL_SOURCECurrent source on stored objects that user is allowed to create ALL_SYNONYMSAll synonyms accessible to the user ALL_TABLESDescription of tables accessible to the user ALL_TAB_COLUMNSColumns of all tables, views and clusters ALL_TAB_COMMENTSComments on tables and views accessible to the user ALL_TAB_GRANTS_MADEUser's grants and grants on user's objects ALL_TAB_GRANTS_RECDGrants on objects for which the user or PUBLIC is the grantee ALL_TAB_PRIVSGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee ALL_TAB_PRIVS_MADEUser's grants and grants on user'

s objects ALL_TAB_PRIVS_RECDGrants on objects for which the user, PUBLIC or enabled role is the grantee ALL_TRIGGERSTriggers accessible to the current user ALL_TRIGGER_COLSColumn usage in user's triggers or in triggers on user's tables ALL_USERSInformation about all users of the database ALL_VIEWSText of views accessible to the user USER_AUDIT_CONNECTAudit trail entries for user logons/logoffs USER_AUDIT_OBJECTAudit 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_SESSIONUSER_AUDIT_STATEMENTAudit trail records concerning grant, revoke, audit, noaudit and alter system USER_AUDIT_TRAILAudit trail entries relevant to the user USER_CATALOGTables, Views, Synonyms and Sequences owned by the user USER_CLUSTERSDescriptions of user's own clusters USER_CLU_COLUMNSMapping of table columns to cluster columns USER_COL_COMMENTSComments on columns of user's tables and views USER_COL_GRANTSGrants on columns for which the user is the owner, grantor or grantee USER_COL_GRANTS_MADEAll grants on columns of objects owned by the user USER_COL_GRANTS_RECDGrants on columns for which the user is the grantee USER_COL_PRIVSGrants on columns for which the user is the owner, grantor or grantee USER_COL_PRIVS_MADEAll grants on columns of objects owned by the user USER_COL_PRIVS_RECDGrants on columns for which the user is the grantee USER_CONSTRAINTSConstraint definitions on user's own tables USER_CONS_COLUMNSInformation about accessible columns in constraint definitions USER_CROSS_REFSCross references for user's views and synonyms USER_DB_LINKSDatabase links owned by the user USER_DEPENDENCIESDependencies to and from a users objects USER_ERRORSCurrent errors on stored objects owned by the user USER_EXTENTSExtents comprising segments owned by the user USER_FREE_SPACEFree extents in tablespaces accessible to the user USER_INDEXESDescription of the user's own indexes USER_IND_COLUMNSCOLUMNs comprising user's INDEXes or on user's TABLESUSER_JOBSAll jobs owned by this user USER_OBJECTSObjects owned by the user USER_OBJECT_SIZESizes, in bytes, of various pl/sql objects USER_OBJ_AUDIT_OPTSAuditing options for user's own tables and views USER_REFRESHAll the refresh groups USER_REFRESH_CHILDRENAll the objects in refresh groups, where the user owns the refresh group USER_RESOURCE_LIMITSDisplay resource limit of the user USER_ROLE_PRIVSRoles granted to current user USER_SEGMENTSStorage allocated for all database segments USER_SEQUENCESDescription of the user's own SEQUENCEs USER_SNAPSHOTSSnapshots the user can look at USER_SNAPSHOT_LOGSAll snapshot logs owned by the user USER_SOURCESource of stored objects accessible to the user USER_SYNONYMSThe user's private synonyms USER_SYS_PRIVSSystem privileges granted to current user USER_TABLESDescription of the user's own tables USER_TABLESPACESDescription of accessible tablespaces USER_TAB_AUDIT_OPTSAuditing options for user'

s own tables and views USER_TAB_COLUMNSColumns of user's tables, views and clusters USER_TAB_COMMENTSComments on the tables and views owned by the user USER_TAB_GRANTSGrants on objects for which the user is the owner, grantor or grantee USER_TAB_GRANTS_MADEAll grants on objects owned by the user USER_TAB_GRANTS_RECDGrants on objects for which the user is the grantee USER_TAB_PRIVSGrants 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_RECDGrants on objects for which the user is the grantee USER_TRIGGERSTriggers owned by the user USER_TRIGGER_COLSColumn usage in user's triggers USER_TS_QUOTASTablespace quotas for the user USER_USERSInformation about the current user USER_VIEWSText of views owned by the user AUDIT_ACTIONSDescription table for audit trail action type codes. Maps action type numbers to action type names COLUMN_PRIVILEGESGrants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee DICTIONARYDescription of data dictionary tables and views DICT_COLUMNSDescription of columns in data dictionary tables and views DUALGLOBAL_NAMEglobal database name INDEX_HISTOGRAMstatistics on keys with repeat count INDEX_STATSstatistics on the b-tree RESOURCE_COSTCost for each resource ROLE_ROLE_PRIVSRoles which are granted to roles ROLE_SYS_PRIVSSystem privileges granted to roles ROLE_TAB_PRIVSTable privileges granted to roles SESSION_PRIVSPrivileges which the user currently has set SESSION_ROLESRoles which the user currently has enabled. TABLE_PRIVILEGESGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee ACCESSIBLE_COLUMNSSynonym for ALL_TAB_COLUMNS ALL_COL_GRANTSSynonym for COLUMN_PRIVILEGES ALL_JOBSSynonym for USER_JOBS ALL_TAB_GRANTSSynonym for TABLE_PRIVILEGES CATSynonym for USER_CATALOG CLU Synonym for USER_CLUSTERS COLSSynonym for USER_TAB_COLUMNS DBA_AUDIT_CONNECT Synonym for USER_AUDIT_CONNECT DBA_AUDIT_RESOURCESynonym for USER_AUDIT_RESOURCE DBA_REFRESH_CHILDRENSynonym for USER_REFRESH_CHILDREN DICTSynonym for DICTIONARY INDSynonym for USER_INDEXES OBJSynonym for USER_OBJECTS SEQSynonym for USER_SEQUENCES SM$VERSIONSynonym for SM_$VERSION SYNSynonym for USER_SYNONYMS TABSSynonym for USER_TABLES V$ACCESSSynonym for V_$ACCESS V$ARCHIVESynonym for V_$ARCHIVE V$BACKUPSynonym for V_$BACKUP V$BGPROCESSSynonym for V_$BGPROCESS V$CIRCUITSynonym for V_$CIRCUIT V$COMPATIBILITYSynonym for V_$COMPATIBILITY V$COMPATSEGSynonym for V_$COMPATSEG V$CONTROLFILESynonym for V_$CONTROLFILE V$DATABASESynonym for V_$DATABASE V$DATAFILESynonym for V_$DATAFILE V$DBFILESynonym for V_$DBFILE V$DBLINKSynonym for V_$DBLINK V$DB_OBJECT_CACHESynonym for V_$DB_OBJECT_CACHE V$DISPATCHERSynonym for V_$DISPATCHER V$ENABLEDPRIVSSynonym for V_$ENABLEDPRIVS V$FILESTATSynonym for V_$FILESTAT V$FIXED_TABLESynonym for V_$FIXED_TABLE V$LATCHSynonym for V_$LATCH V$LATCHHOLDERSynonym for V_$LATCHHOLDER V$LATCHNAMESynonym for V_$LATCHNAME V$LIBRARYCACHESynonym for V_$LIBRARYCACHE V$LICENSESynonym for V_$LICENSE V$LOADCSTATSynonym for V_$LOADCSTAT V$LOADTSTATSynonym for V_$LOADTSTAT V$LOCKSynonym for V_$LOCK V$LOGSynonym for V_$LOG V$LOGFILESynonym for V_$LOGFILE V$LOGHISTSynonym for V_$LOGHIST V$LOG_HISTORYSynonym for V_$LOG_HISTORY V$MLS_PARAMETERSSynonym for V_$MLS_PARAMETERS V$MTSSynonym for V_$MTS V$NLS_PARAMETERS Synonym for V_$NLS_PARAMETERS V$NLS_VALID_VALUESSynonym 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_SYSSTATSynonym for V_$PQ_SYSSTAT V$PROCESSSynonym for V_$PROCESS V$QUEUESynonym for V_$QUEUE V$RECOVERY_LOGSynonym for V_$RECOVERY_LOG V$RECOVER_FILESynonym for V_$RECOVER_FILE V$REQDISTSynonym for V_$REQDIST V$RESOURCESynonym for V_$RESOURCE V$ROLLNAMESynonym for V_$ROLLNAME V$ROLLSTATSynonym for V_$ROLLSTAT V$ROWCACHESynonym for V_$ROWCACHE V$SESSIONSynonym for V_$SESSION V$SESSION_CURSOR_CACHESynonym for V_$SESSION_CURSOR_CACHE V$SESSION_EVENTSynonym for V_$SESSION_EVENT V$SESSION_WAITSynonym for V_$SESSION_WAIT V$SESSTATSynonym for V_$SESSTAT V$SESS_IOSynonym for V_$SESS_IO V$SGASynonym for V_$SGA V$SGASTATSynonym for V_$SGASTAT V$SHARED_SERVERSynonym for V_$SHARED_SERVER V$SQLAREASynonym for V_$SQLAREA V$STATNAMESynonym for V_$STATNAME V$SYSSTATSynonym for V_$SYSSTAT V$SYSTEM_CURSOR_CACHESynonym for V_$SYSTEM_CURSOR_CACHE V$SYSTEM_EVENTSynonym for V_$SYSTEM_EVENT V$THREADSynonym for V_$THREAD V$TIMERSynonym for V_$TIMER V$TRANSACTIONSynonym for V_$TRANSACTION V$TYPE_SIZESynonym for V_$TYPE_SIZE V$VERSIONSynonym for V_$VERSION V$WAITSTATSynonym for V_$WAITSTAT V$_LOCKSynonym for V_$_LOCK

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有