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_CATALOGAll tables, views, synonyms, sequences accessible to the userALL_COL_COMMENTSComments on columns of accessible tables and viewsALL_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 granteeALL_COL_PRIVSGrants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the granteeALL_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 granteeALL_CONSTRAINTSConstraint definitions on accessible tablesALL_CONS_COLUMNSInformation about accessible columns in constraint definitionsALL_DB_LINKSDatabase links accessible to the userALL_DEF_AUDIT_OPTSAuditing options for newly created objectsALL_DEPENDENCIESDependencies to and from objects accessible to the userALL_ERRORSCurrent errors on stored objects that user is allowed to createALL_INDEXESDescriptions of indexes on tables accessible to the userALL_IND_COLUMNSCOLUMNs comprising INDEXes on accessible TABLESALL_OBJECTSObjects accessible to the userALL_REFRESHAll the refresh groups that the user can touchALL_REFRESH_CHILDRENAll the objects in refresh groups, where the user can touch the groupALL_SEQUENCESDescription of SEQUENCEs accessible to the userALL_SNAPSHOTSSnapshots the user can look atALL_SOURCECurrent source on stored objects that user is allowed to createALL_SYNONYMSAll synonyms accessible to the userALL_TABLESDescription of tables accessible to the userALL_TAB_COLUMNSColumns of all tables, views and clustersALL_TAB_COMMENTSComments on tables and views accessible to the userALL_TAB_GRANTS_MADEUser's grants and grants on user's objectsALL_TAB_GRANTS_RECDGrants on objects for which the user or PUBLIC is the granteeALL_TAB_PRIVSGrants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the granteeALL_TAB_PRIVS_MADEUser's grants and grants on user's objectsALL_TAB_PRIVS_RECDGrants on objects for which the user, PUBLIC or enabled role is the granteeALL_TRIGGERSTriggers accessible to the current userALL_TRIGGER_COLSColumn usage in user's triggers or in triggers on user's tablesALL_USERSInformation about all users of the databaseALL_VIEWSText of views accessible to the userUSER_AUDIT_CONNECTAudit trail entries for user logons/logoffsUSER_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, userUSER_AUDIT_SESSION USER_AUDIT_STATEMENTAudit trail records concerning grant, revoke, audit, noaudit and alter systemUSER_AUDIT_TRAILAudit trail entries relevant to the userUSER_CATALOGTables, Views, Synonyms and Sequences owned by the userUSER_CLUSTERSDescriptions of user's own clustersUSER_CLU_COLUMNSMapping of table columns to cluster columnsUSER_COL_COMMENTSComments on columns of user's tables and viewsUSER_COL_GRANTSGrants on columns for which the user is the owner, grantor or granteeUSER_COL_GRANTS_MADEAll grants on columns of objects owned by the userUSER_COL_GRANTS_RECDGrants on columns for which the user is the granteeUSER_COL_PRIVSGrants on columns for which the user is the owner, grantor or granteeUSER_COL_PRIVS_MADEAll grants on columns of objects owned by the userUSER_COL_PRIVS_RECDGrants on columns for which the user is the granteeUSER_CONSTRAINTSConstraint definitions on user's own tablesUSER_CONS_COLUMNSInformation about accessible columns in constraint definitionsUSER_CROSS_REFSCross references for user's views and synonymsUSER_DB_LINKSDatabase links owned by the userUSER_DEPENDENCIESDependencies to and from a users objectsUSER_ERRORSCurrent errors on stored objects owned by the userUSER_EXTENTSExtents comprising segments owned by the userUSER_FREE_SPACEFree extents in tablespaces accessible to the userUSER_INDEXESDescription of the user's own indexesUSER_IND_COLUMNSCOLUMNs comprising user's INDEXes or on user's TABLESUSER_JOBSAll jobs owned by this userUSER_OBJECTSObjects owned by the userUSER_OBJECT_SIZESizes, in bytes, of various pl/sql objectsUSER_OBJ_AUDIT_OPTSAuditing options for user's own tables and viewsUSER_REFRESHAll the refresh groupsUSER_REFRESH_CHILDRENAll the objects in refresh groups, where the user owns the refresh groupUSER_RESOURCE_LIMITSDisplay resource limit of the userUSER_ROLE_PRIVSRoles granted to current userUSER_SEGMENTSStorage allocated for all database segmentsUSER_SEQUENCESDescription of the user's own SEQUENCEsUSER_SNAPSHOTSSnapshots the user can look atUSER_SNAPSHOT_LOGSAll snapshot logs owned by the userUSER_SOURCESource of stored objects accessible to the userUSER_SYNONYMSThe user's private synonymsUSER_SYS_PRIVSSystem privileges granted to current userUSER_TABLESDescription of the user's own tablesUSER_TABLESPACESDescription of accessible tablespacesUSER_TAB_AUDIT_OPTSAuditing options for user's own tables and viewsUSER_TAB_COLUMNSColumns of user's tables, views and clustersUSER_TAB_COMMENTSComments on the tables and views owned by the userUSER_TAB_GRANTSGrants on objects for which the user is the owner, grantor or granteeUSER_TAB_GRANTS_MADEAll grants on objects owned by the userUSER_TAB_GRANTS_RECDGrants on objects for which the user is the granteeUSER_TAB_PRIVSGrants on objects for which the user is the owner, grantor or granteeUSER_TAB_PRIVS_MADEAll grants on objects owned by the userUSER_TAB_PRIVS_RECDGrants on objects for which the user is the granteeUSER_TRIGGERSTriggers owned by the userUSER_TRIGGER_COLSColumn usage in user's triggersUSER_TS_QUOTASTablespace quotas for the userUSER_USERSInformation about the current userUSER_VIEWSText of views owned by the userAUDIT_ACTIONSDescription table for audit trail action type codes. Maps action type numbers to action type namesCOLUMN_PRIVILEGESGrants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the granteeDICTIONARYDescription of data dictionary tables and viewsDICT_COLUMNSDescription of columns in data dictionary tables and viewsDUAL GLOBAL_NAMEglobal database nameINDEX_HISTOGRAMstatistics on keys with repeat countINDEX_STATSstatistics on the b-treeRESOURCE_COSTCost for each resourceROLE_ROLE_PRIVSRoles which are granted to rolesROLE_SYS_PRIVSSystem privileges granted to rolesROLE_TAB_PRIVSTable privileges granted to rolesSESSION_PRIVSPrivileges which the user currently has setSESSION_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 granteeACCESSIBLE_COLUMNSSynonym for ALL_TAB_COLUMNSALL_COL_GRANTSSynonym for COLUMN_PRIVILEGESALL_JOBSSynonym for USER_JOBSALL_TAB_GRANTSSynonym for TABLE_PRIVILEGESCATSynonym for USER_CATALOGCLUSynonym for USER_CLUSTERSCOLSSynonym for USER_TAB_COLUMNSDBA_AUDIT_CONNECTSynonym for USER_AUDIT_CONNECTDBA_AUDIT_RESOURCESynonym for USER_AUDIT_RESOURCEDBA_REFRESH_CHILDRENSynonym for USER_REFRESH_CHILDRENDICTSynonym for DICTIONARYINDSynonym for USER_INDEXESOBJSynonym for USER_OBJECTSSEQSynonym for USER_SEQUENCESSM$VERSIONSynonym for SM_$VERSIONSYNSynonym for USER_SYNONYMSTABSSynonym for USER_TABLESV$ACCESSSynonym for V_$ACCESSV$ARCHIVESynonym for V_$ARCHIVEV$BACKUPSynonym for V_$BACKUPV$BGPROCESSSynonym for V_$BGPROCESSV$CIRCUITSynonym for V_$CIRCUITV$COMPATIBILITYSynonym for V_$COMPATIBILITYV$COMPATSEGSynonym for V_$COMPATSEGV$CONTROLFILESynonym for V_$CONTROLFILEV$DATABASESynonym for V_$DATABASEV$DATAFILESynonym for V_$DATAFILEV$DBFILESynonym for V_$DBFILEV$DBLINKSynonym for V_$DBLINKV$DB_OBJECT_CACHESynonym for V_$DB_OBJECT_CACHEV$DISPATCHERSynonym for V_$DISPATCHERV$ENABLEDPRIVSSynonym for V_$ENABLEDPRIVSV$FILESTATSynonym for V_$FILESTATV$FIXED_TABLESynonym for V_$FIXED_TABLEV$LATCHSynonym for V_$LATCHV$LATCHHOLDERSynonym for V_$LATCHHOLDERV$LATCHNAMESynonym for V_$LATCHNAMEV$LIBRARYCACHESynonym for V_$LIBRARYCACHEV$LICENSESynonym for V_$LICENSEV$LOADCSTATSynonym for V_$LOADCSTATV$LOADTSTATSynonym for V_$LOADTSTATV$LOCKSynonym for V_$LOCKV$LOGSynonym for V_$LOGV$LOGFILESynonym for V_$LOGFILEV$LOGHISTSynonym for V_$LOGHISTV$LOG_HISTORYSynonym for V_$LOG_HISTORYV$MLS_PARAMETERSSynonym for V_$MLS_PARAMETERSV$MTSSynonym for V_$MTSV$NLS_PARAMETERSSynonym for V_$NLS_PARAMETERSV$NLS_VALID_VALUESSynonym for V_$NLS_VALID_VALUESV$OPEN_CURSORSynonym for V_$OPEN_CURSORV$OPTIONSynonym for V_$OPTIONV$PARAMETERSynonym for V_$PARAMETERV$PQ_SESSTATSynonym for V_$PQ_SESSTATV$PQ_SLAVESynonym for V_$PQ_SLAVEV$PQ_SYSSTATSynonym for V_$PQ_SYSSTATV$PROCESSSynonym for V_$PROCESSV$QUEUESynonym for V_$QUEUEV$RECOVERY_LOGSynonym for V_$RECOVERY_LOGV$RECOVER_FILESynonym for V_$RECOVER_FILEV$REQDISTSynonym for V_$REQDISTV$RESOURCESynonym for V_$RESOURCEV$ROLLNAMESynonym for V_$ROLLNAMEV$ROLLSTATSynonym for V_$ROLLSTATV$ROWCACHESynonym for V_$ROWCACHEV$SESSIONSynonym for V_$SESSIONV$SESSION_CURSOR_CACHESynonym for V_$SESSION_CURSOR_CACHEV$SESSION_EVENTSynonym for V_$SESSION_EVENTV$SESSION_WAITSynonym for V_$SESSION_WAITV$SESSTATSynonym for V_$SESSTATV$SESS_IOSynonym for V_$SESS_IOV$SGASynonym for V_$SGAV$SGASTATSynonym for V_$SGASTATV$SHARED_SERVERSynonym for V_$SHARED_SERVERV$SQLAREASynonym for V_$SQLAREAV$STATNAMESynonym for V_$STATNAMEV$SYSSTATSynonym for V_$SYSSTATV$SYSTEM_CURSOR_CACHESynonym for V_$SYSTEM_CURSOR_CACHEV$SYSTEM_EVENTSynonym for V_$SYSTEM_EVENTV$THREADSynonym for V_$THREADV$TIMERSynonym for V_$TIMERV$TRANSACTIONSynonym for V_$TRANSACTIONV$TYPE_SIZESynonym for V_$TYPE_SIZEV$VERSIONSynonym for V_$VERSIONV$WAITSTATSynonym for V_$WAITSTATV$_LOCKSynonym for V_$_LOCK