Oracle数据库的数据字典

来源：互联网发布：单片机串口通信编辑：程序博客网时间：2024/04/29 02:23

以下表格中收集了Oracle 数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用‘Describe’语句来查询。

命名说明：

Oracle 数据字典中，对象名称多数以"USER."，"ALL."，"DBA."为前缀"USER."视图中记录通常记录执行查询的帐户所拥有的对象的信息，"ALL."视图中记录包括"USER"记录和授权至PUBLIC或用户的对象的信息，"DBA."视图包含所有数据库对象，而不管其所有者。

使用举例：

select*fromdba_data_files

查询表空间的信息(当前用户必须拥有DBA角色)。

selectowner,object_name,object_typefromall_objects

查询某一用户下的所有表、过程、函数等信息。

视图名

描述

ALL_CATALOGAlltables,views,synonyms,sequencesaccessibletotheuser

ALL_COL_COMMENTSCommentsoncolumnsofaccessibletablesandviews

ALL_COL_GRANTS_MADEGrantsoncolumnsforwhichtheuserisownerorgrantor

ALL_COL_GRANTS_RECDGrantsoncolumnsforwhichtheuserorPUBLICisthegrantee

ALL_COL_PRIVSGrantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ALL_COL_PRIVS_MADEGrantsoncolumnsforwhichtheuserisownerorgrantor

ALL_COL_PRIVS_RECDGrantsoncolumnsforwhichtheuser,PUBLICorenabledroleisthegrantee

ALL_CONSTRAINTSConstraintdefinitionsonaccessibletables

ALL_CONS_COLUMNSInformationaboutaccessiblecolumnsinconstraintdefinitions

ALL_DB_LINKSDatabaselinksaccessibletotheuser

ALL_DEF_AUDIT_OPTSAuditingoptionsfornewlycreatedobjects

ALL_DEPENDENCIESDependenciestoandfromobjectsaccessibletotheuser

ALL_ERRORSCurrenterrorsonstoredobjectsthatuserisallowedtocreate

ALL_INDEXESDescriptionsofindexesontablesaccessibletotheuser

ALL_IND_COLUMNSCOLUMNscomprisingINDEXesonaccessibleTABLES

ALL_OBJECTSObjectsaccessibletotheuser

ALL_REFRESHAlltherefreshgroupsthattheusercantouch

ALL_REFRESH_CHILDRENAlltheobjectsinrefreshgroups,wheretheusercantouchthegroup

ALL_SEQUENCESDescriptionofSEQUENCEsaccessibletotheuser

ALL_SNAPSHOTSSnapshotstheusercanlookat

ALL_SOURCECurrentsourceonstoredobjectsthatuserisallowedtocreate

ALL_SYNONYMSAllsynonymsaccessibletotheuser

ALL_TABLESDescriptionoftablesaccessibletotheuser

ALL_TAB_COLUMNSColumnsofalltables,viewsandclusters

ALL_TAB_COMMENTSCommentsontablesandviewsaccessibletotheuser

ALL_TAB_GRANTS_MADEUser'sgrantsandgrantsonuser'sobjects

ALL_TAB_GRANTS_RECDGrantsonobjectsforwhichtheuserorPUBLICisthegrantee

ALL_TAB_PRIVSGrantsonobjectsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ALL_TAB_PRIVS_MADEUser'sgrantsandgrantsonuser'sobjects

ALL_TAB_PRIVS_RECDGrantsonobjectsforwhichtheuser,PUBLICorenabledroleisthegrantee

ALL_TRIGGERSTriggersaccessibletothecurrentuser

ALL_TRIGGER_COLSColumnusageinuser'striggersorintriggersonuser'stables

ALL_USERSInformationaboutallusersofthedatabase

ALL_VIEWSTextofviewsaccessibletotheuser

USER_AUDIT_CONNECTAudittrailentriesforuserlogons/logoffs

USER_AUDIT_OBJECTAudittrailrecordsforstatementsconcerningobjects,specifically:table,cluster,view,index,sequence,[public]databaselink,[public]synonym,procedure,trigger,rollbacksegment,tablespace,role,user

USER_AUDIT_SESSION

USER_AUDIT_STATEMENTAudittrailrecordsconcerninggrant,revoke,audit,noauditandaltersystem

USER_AUDIT_TRAILAudittrailentriesrelevanttotheuser

USER_CATALOGTables,Views,SynonymsandSequencesownedbytheuser

USER_CLUSTERSDescriptionsofuser'sownclusters

USER_CLU_COLUMNSMappingoftablecolumnstoclustercolumns

USER_COL_COMMENTSCommentsoncolumnsofuser'stablesandviews

USER_COL_GRANTSGrantsoncolumnsforwhichtheuseristheowner,grantororgrantee

USER_COL_GRANTS_MADEAllgrantsoncolumnsofobjectsownedbytheuser

USER_COL_GRANTS_RECDGrantsoncolumnsforwhichtheuseristhegrantee

USER_COL_PRIVSGrantsoncolumnsforwhichtheuseristheowner,grantororgrantee

USER_COL_PRIVS_MADEAllgrantsoncolumnsofobjectsownedbytheuser

USER_COL_PRIVS_RECDGrantsoncolumnsforwhichtheuseristhegrantee

USER_CONSTRAINTSConstraintdefinitionsonuser'sowntables

USER_CONS_COLUMNSInformationaboutaccessiblecolumnsinconstraintdefinitions

USER_CROSS_REFSCrossreferencesforuser'sviewsandsynonyms

USER_DB_LINKSDatabaselinksownedbytheuser

USER_DEPENDENCIESDependenciestoandfromausersobjects

USER_ERRORSCurrenterrorsonstoredobjectsownedbytheuser

USER_EXTENTSExtentscomprisingsegmentsownedbytheuser

USER_FREE_SPACEFreeextentsintablespacesaccessibletotheuser

USER_INDEXESDescriptionoftheuser'sownindexes

USER_IND_COLUMNSCOLUMNscomprisinguser'sINDEXesoronuser'sTABLES

USER_JOBSAlljobsownedbythisuser

USER_OBJECTSObjectsownedbytheuser

USER_OBJECT_SIZESizes,inbytes,ofvariouspl/sqlobjects

USER_OBJ_AUDIT_OPTSAuditingoptionsforuser'sowntablesandviews

USER_REFRESHAlltherefreshgroups

USER_REFRESH_CHILDRENAlltheobjectsinrefreshgroups,wheretheuserownstherefreshgroup

USER_RESOURCE_LIMITSDisplayresourcelimitoftheuser

USER_ROLE_PRIVSRolesgrantedtocurrentuser

USER_SEGMENTSStorageallocatedforalldatabasesegments

USER_SEQUENCESDescriptionoftheuser'sownSEQUENCEs

USER_SNAPSHOTSSnapshotstheusercanlookat

USER_SNAPSHOT_LOGSAllsnapshotlogsownedbytheuser

USER_SOURCESourceofstoredobjectsaccessibletotheuser

USER_SYNONYMSTheuser'sprivatesynonyms

USER_SYS_PRIVSSystemprivilegesgrantedtocurrentuser

USER_TABLESDescriptionoftheuser'sowntables

USER_TABLESPACESDescriptionofaccessibletablespaces

USER_TAB_AUDIT_OPTSAuditingoptionsforuser'sowntablesandviews

USER_TAB_COLUMNSColumnsofuser'stables,viewsandclusters

USER_TAB_COMMENTSCommentsonthetablesandviewsownedbytheuser

USER_TAB_GRANTSGrantsonobjectsforwhichtheuseristheowner,grantororgrantee

USER_TAB_GRANTS_MADEAllgrantsonobjectsownedbytheuser

USER_TAB_GRANTS_RECDGrantsonobjectsforwhichtheuseristhegrantee

USER_TAB_PRIVSGrantsonobjectsforwhichtheuseristheowner,grantororgrantee

USER_TAB_PRIVS_MADEAllgrantsonobjectsownedbytheuser

USER_TAB_PRIVS_RECDGrantsonobjectsforwhichtheuseristhegrantee

USER_TRIGGERSTriggersownedbytheuser

USER_TRIGGER_COLSColumnusageinuser'striggers

USER_TS_QUOTASTablespacequotasfortheuser

USER_USERSInformationaboutthecurrentuser

USER_VIEWSTextofviewsownedbytheuser

AUDIT_ACTIONSDescriptiontableforaudittrailactiontypecodes.Mapsactiontypenumberstoactiontypenames

COLUMN_PRIVILEGESGrantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

DICTIONARYDescriptionofdatadictionarytablesandviews

DICT_COLUMNSDescriptionofcolumnsindatadictionarytablesandviews

DUAL

GLOBAL_NAMEglobaldatabasename

INDEX_HISTOGRAMstatisticsonkeyswithrepeatcount

INDEX_STATSstatisticsontheb-tree

RESOURCE_COSTCostforeachresource

ROLE_ROLE_PRIVSRoleswhicharegrantedtoroles

ROLE_SYS_PRIVSSystemprivilegesgrantedtoroles

ROLE_TAB_PRIVSTableprivilegesgrantedtoroles

SESSION_PRIVSPrivilegeswhichtheusercurrentlyhasset

SESSION_ROLESRoleswhichtheusercurrentlyhasenabled.

TABLE_PRIVILEGESGrantsonobjectsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ACCESSIBLE_COLUMNSSynonymforALL_TAB_COLUMNS

ALL_COL_GRANTSSynonymforCOLUMN_PRIVILEGES

ALL_JOBSSynonymforUSER_JOBS

ALL_TAB_GRANTSSynonymforTABLE_PRIVILEGES

CATSynonymforUSER_CATALOG

CLUSynonymforUSER_CLUSTERS

COLSSynonymforUSER_TAB_COLUMNS

DBA_AUDIT_CONNECTSynonymforUSER_AUDIT_CONNECT

DBA_AUDIT_RESOURCESynonymforUSER_AUDIT_RESOURCE

DBA_REFRESH_CHILDRENSynonymforUSER_REFRESH_CHILDREN

DICTSynonymforDICTIONARY

INDSynonymforUSER_INDEXES

OBJSynonymforUSER_OBJECTS

SEQSynonymforUSER_SEQUENCES

SM$VERSIONSynonymforSM_$VERSION

SYNSynonymforUSER_SYNONYMS

TABSSynonymforUSER_TABLES

V$ACCESSSynonymforV_$ACCESS

V$ARCHIVESynonymforV_$ARCHIVE

V$BACKUPSynonymforV_$BACKUP

V$BGPROCESSSynonymforV_$BGPROCESS

V$CIRCUITSynonymforV_$CIRCUIT

V$COMPATIBILITYSynonymforV_$COMPATIBILITY

V$COMPATSEGSynonymforV_$COMPATSEG

V$CONTROLFILESynonymforV_$CONTROLFILE

V$DATABASESynonymforV_$DATABASE

V$DATAFILESynonymforV_$DATAFILE

V$DBFILESynonymforV_$DBFILE

V$DBLINKSynonymforV_$DBLINK

V$DB_OBJECT_CACHESynonymforV_$DB_OBJECT_CACHE

V$DISPATCHERSynonymforV_$DISPATCHER

V$ENABLEDPRIVSSynonymforV_$ENABLEDPRIVS

V$FILESTATSynonymforV_$FILESTAT

V$FIXED_TABLESynonymforV_$FIXED_TABLE

V$LATCHSynonymforV_$LATCH

V$LATCHHOLDERSynonymforV_$LATCHHOLDER

V$LATCHNAMESynonymforV_$LATCHNAME

V$LIBRARYCACHESynonymforV_$LIBRARYCACHE

V$LICENSESynonymforV_$LICENSE

V$LOADCSTATSynonymforV_$LOADCSTAT

V$LOADTSTATSynonymforV_$LOADTSTAT

V$LOCKSynonymforV_$LOCK

V$LOGSynonymforV_$LOG

V$LOGFILESynonymforV_$LOGFILE

V$LOGHISTSynonymforV_$LOGHIST

V$LOG_HISTORYSynonymforV_$LOG_HISTORY

V$MLS_PARAMETERSSynonymforV_$MLS_PARAMETERS

V$MTSSynonymforV_$MTS

V$NLS_PARAMETERSSynonymforV_$NLS_PARAMETERS

V$NLS_VALID_VALUESSynonymforV_$NLS_VALID_VALUES

V$OPEN_CURSORSynonymforV_$OPEN_CURSOR

V$OPTIONSynonymforV_$OPTION

V$PARAMETERSynonymforV_$PARAMETER

V$PQ_SESSTATSynonymforV_$PQ_SESSTAT

V$PQ_SLAVESynonymforV_$PQ_SLAVE

V$PQ_SYSSTATSynonymforV_$PQ_SYSSTAT

V$PROCESSSynonymforV_$PROCESS

V$QUEUESynonymforV_$QUEUE

V$RECOVERY_LOGSynonymforV_$RECOVERY_LOG

V$RECOVER_FILESynonymforV_$RECOVER_FILE

V$REQDISTSynonymforV_$REQDIST

V$RESOURCESynonymforV_$RESOURCE

V$ROLLNAMESynonymforV_$ROLLNAME

V$ROLLSTATSynonymforV_$ROLLSTAT

V$ROWCACHESynonymforV_$ROWCACHE

V$SESSIONSynonymforV_$SESSION

V$SESSION_CURSOR_CACHESynonymforV_$SESSION_CURSOR_CACHE

V$SESSION_EVENTSynonymforV_$SESSION_EVENT

V$SESSION_WAITSynonymforV_$SESSION_WAIT

V$SESSTATSynonymforV_$SESSTAT

V$SESS_IOSynonymforV_$SESS_IO

V$SGASynonymforV_$SGA

V$SGASTATSynonymforV_$SGASTAT

V$SHARED_SERVERSynonymforV_$SHARED_SERVER

V$SQLAREASynonymforV_$SQLAREA

V$STATNAMESynonymforV_$STATNAME

V$SYSSTATSynonymforV_$SYSSTAT

V$SYSTEM_CURSOR_CACHESynonymforV_$SYSTEM_CURSOR_CACHE

V$SYSTEM_EVENTSynonymforV_$SYSTEM_EVENT

V$THREADSynonymforV_$THREAD

V$TIMERSynonymforV_$TIMER

V$TRANSACTIONSynonymforV_$TRANSACTION

V$TYPE_SIZESynonymforV_$TYPE_SIZE

V$VERSIONSynonymforV_$VERSION

V$WAITSTATSynonymforV_$WAITSTAT

V$_LOCKSynonymforV_$_LOCK