《Oracle常用数据字典.pdf》由会员分享，可在线阅读，更多相关《Oracle常用数据字典.pdf（6页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、OracleOracle 常用数据字典常用数据字典http:/ Oracle 数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用Describe语句来查询。命名说明：Oracle 数据字典中，对象名称多数以USER.，ALL.，DBA.为前缀USER.视图中记录通常记录执行查询的帐户所拥有的对象的信息，ALL.视图中记录包括USER记录和授权至 PUBLIC 或用户的对象的信息，DBA.视图包含所有数据库对象，而不管其所有者。使用举例：select*from dba_data_files查询表空间的信息(当前用户必须拥有 DBA 角色)。select owner,object_nam
2、e,object_type from all_objects查询某一用户下的所有表、过程、函数等信息视图名ALL_CATALOGALL_COL_COMMENTSALL_COL_GRANTS_MADEALL_COL_GRANTS_RECDALL_COL_PRIVSALL_COL_PRIVS_MADEALL_COL_PRIVS_RECDALL_CONSTRAINTSALL_CONS_COLUMNSALL_DB_LINKSALL_DEF_AUDIT_OPTSALL_DEPENDENCIESALL_ERRORSALL_INDEXESALL_IND_COLUMNSALL_OBJECTSALL_REFRE
3、SHuser描述All tables,views,synonyms,sequences accessible to theComments on columns of accessible tables and viewsGrants on columns for which the user is owner or grantorGrants on columns for which the user or PUBLIC is the granteeGrants on columns for which the user is the grantor,grantee,owner,or an
4、enabled role or PUBLIC is the granteeGrants on columns for which the user is owner or grantorGrants on columns for which the user,PUBLIC or enabled roleis the granteeConstraint definitions on accessible tablesInformation about accessible columns in constraintdefinitionsDatabase links accessible to t
5、he userAuditing options for newly created objectsDependencies to and from objects accessible to the userCurrent errors on stored objects that user is allowed tocreateDescriptions of indexes on tables accessible to the userCOLUMNs comprising INDEXes on accessible TABLESObjects accessible to the userA
6、ll the refresh groups that the user can touchALL_REFRESH_CHILDRENALL_SEQUENCESALL_SNAPSHOTSALL_SOURCEALL_SYNONYMSALL_TABLESALL_TAB_COLUMNSALL_TAB_COMMENTSALL_TAB_GRANTS_MADEALL_TAB_GRANTS_RECDALL_TAB_PRIVSALL_TAB_PRIVS_MADEALL_TAB_PRIVS_RECDALL_TRIGGERSALL_TRIGGER_COLSALL_USERSALL_VIEWSUSER_AUDIT_CO
7、NNECTUSER_AUDIT_OBJECTAll the objects in refresh groups,where the user can touchthe groupDescription of SEQUENCEs accessible to the userSnapshots the user can look atCurrent source on stored objects that user is allowed tocreateAll synonyms accessible to the userDescription of tables accessible to t
8、he userColumns of all tables,views and clustersComments on tables and views accessible to the userUsers grants and grants on users objectsGrants on objects for which the user or PUBLIC is the granteeGrants on objects for which the user is the grantor,grantee,owner,or an enabled role or PUBLIC is the
9、 granteeUsers grants and grants on users objectsGrants on objects for which the user,PUBLIC or enabled roleis the granteeTriggers accessible to the current userColumn usage in users triggers or in triggers on userstablesInformation about all users of the databaseText of views accessible to the userA
10、udit trail entries for user logons/logoffsAudit 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_SESSIONUSER_AUDIT_STATEMENTUSER_AUDIT_TRAILUSER_CATALOG
11、USER_CLUSTERSUSER_CLU_COLUMNSUSER_COL_COMMENTSUSER_COL_GRANTSUSER_COL_GRANTS_MADEUSER_COL_GRANTS_RECDUSER_COL_PRIVSAudit trail records concerning grant,revoke,audit,noaudit and alter systemAudit trail entries relevant to the userTables,Views,Synonyms and Sequences owned by the userDescriptions of us
12、ers own clustersMapping of table columns to cluster columnsComments on columns of users tables and viewsGrants on columns for which the user is the owner,grantoror granteeAll grants on columns of objects owned by the userGrants on columns for which the user is the granteeGrants on columns for which
13、the user is the owner,grantoror granteeUSER_COL_PRIVS_MADEUSER_COL_PRIVS_RECDUSER_CONSTRAINTSUSER_CONS_COLUMNSUSER_CROSS_REFSUSER_DB_LINKSUSER_DEPENDENCIESUSER_ERRORSUSER_EXTENTSUSER_FREE_SPACEUSER_INDEXESUSER_IND_COLUMNSUSER_JOBSUSER_OBJECTSUSER_OBJECT_SIZEUSER_OBJ_AUDIT_OPTSUSER_REFRESHUSER_REFRES
14、H_CHILDRENUSER_RESOURCE_LIMITSUSER_ROLE_PRIVSUSER_SEGMENTSUSER_SEQUENCESUSER_SNAPSHOTSUSER_SNAPSHOT_LOGSUSER_SOURCEUSER_SYNONYMSUSER_SYS_PRIVSUSER_TABLESUSER_TABLESPACESUSER_TAB_AUDIT_OPTSUSER_TAB_COLUMNSUSER_TAB_COMMENTSUSER_TAB_GRANTSUSER_TAB_GRANTS_MADEUSER_TAB_GRANTS_RECDUSER_TAB_PRIVSUSER_TAB_P
15、RIVS_MADEAll grants on columns of objects owned by the userGrants on columns for which the user is the granteeConstraint definitions on users own tablesInformation about accessible columns in constraintdefinitionsCross references for users views and synonymsDatabase links owned by the userDependenci
16、es to and from a users objectsCurrent errors on stored objects owned by the userExtents comprising segments owned by the userFree extents in tablespaces accessible to the userDescription of the users own indexesCOLUMNs comprising users INDEXes or on users TABLESAll jobs owned by this userObjects own
17、ed by the userSizes,in bytes,of various pl/sql objectsAuditing options for users own tables and viewsAll the refresh groupsAll the objects in refresh groups,where the user owns therefresh groupDisplay resource limit of the userRoles granted to current userStorage allocated for all database segmentsD
18、escription of the users own SEQUENCEsSnapshots the user can look atAll snapshot logs owned by the userSource of stored objects accessible to the userThe users private synonymsSystem privileges granted to current userDescription of the users own tablesDescription of accessible tablespacesAuditing opt
19、ions for users own tables and viewsColumns of users tables,views and clustersComments on the tables and views owned by the userGrants on objects for which the user is the owner,grantoror granteeAll grants on objects owned by the userGrants on objects for which the user is the granteeGrants on object
20、s for which the user is the owner,grantoror granteeAll grants on objects owned by the userUSER_TAB_PRIVS_RECDUSER_TRIGGERSUSER_TRIGGER_COLSUSER_TS_QUOTASUSER_USERSUSER_VIEWSAUDIT_ACTIONSCOLUMN_PRIVILEGESDICTIONARYDICT_COLUMNSDUALGLOBAL_NAMEINDEX_HISTOGRAMINDEX_STATSRESOURCE_COSTROLE_ROLE_PRIVSROLE_S
21、YS_PRIVSROLE_TAB_PRIVSSESSION_PRIVSSESSION_ROLESTABLE_PRIVILEGESACCESSIBLE_COLUMNSALL_COL_GRANTSALL_JOBSALL_TAB_GRANTSCATCLUCOLSDBA_AUDIT_CONNECTDBA_AUDIT_RESOURCEDBA_REFRESH_CHILDRENDICTINDOBJSEQSM$VERSIONSYNGrants on objects for which the user is the granteeTriggers owned by the userColumn usage i
22、n users triggersTablespace quotas for the userInformation about the current userText of views owned by the userDescription table for audit trail action type codes.Mapsaction type numbers to action type namesGrants on columns for which the user is the grantor,grantee,owner,or an enabled role or PUBLI
23、C is the granteeDescription of data dictionary tables and viewsDescription of columns in data dictionary tables and viewsglobal database namestatistics on keys with repeat countstatistics on the b-treeCost for each resourceRoles which are granted to rolesSystem privileges granted to rolesTable privi
24、leges granted to rolesPrivileges which the user currently has setRoles which the user currently has enabled.Grants on objects for which the user is the grantor,grantee,owner,or an enabled role or PUBLIC is the granteeSynonym for ALL_TAB_COLUMNSSynonym for COLUMN_PRIVILEGESSynonym for USER_JOBSSynony
25、m for TABLE_PRIVILEGESSynonym for USER_CATALOGSynonym for USER_CLUSTERSSynonym for USER_TAB_COLUMNSSynonym for USER_AUDIT_CONNECTSynonym for USER_AUDIT_RESOURCESynonym for USER_REFRESH_CHILDRENSynonym for DICTIONARYSynonym for USER_INDEXESSynonym for USER_OBJECTSSynonym for USER_SEQUENCESSynonym for
26、 SM_$VERSIONSynonym for USER_SYNONYMSTABSV$ACCESSV$ARCHIVEV$BACKUPV$BGPROCESSV$CIRCUITV$COMPATIBILITYV$COMPATSEGV$CONTROLFILEV$DATABASEV$DATAFILEV$DBFILEV$DBLINKV$DB_OBJECT_CACHEV$DISPATCHERV$ENABLEDPRIVSV$FILESTATV$FIXED_TABLEV$LATCHV$LATCHHOLDERV$LATCHNAMEV$LIBRARYCACHEV$LICENSEV$LOADCSTATV$LOADTS
27、TATV$LOCKV$LOGV$LOGFILEV$LOGHISTV$LOG_HISTORYV$MLS_PARAMETERSV$MTSV$NLS_PARAMETERSV$NLS_VALID_VALUESV$OPEN_CURSORV$OPTIONV$PARAMETERV$PQ_SESSTATV$PQ_SLAVEV$PQ_SYSSTATSynonym for USER_TABLESSynonym for V_$ACCESSSynonym for V_$ARCHIVESynonym for V_$BACKUPSynonym for V_$BGPROCESSSynonym for V_$CIRCUITS
28、ynonym for V_$COMPATIBILITYSynonym for V_$COMPATSEGSynonym for V_$CONTROLFILESynonym for V_$DATABASESynonym for V_$DATAFILESynonym for V_$DBFILESynonym for V_$DBLINKSynonym for V_$DB_OBJECT_CACHESynonym for V_$DISPATCHERSynonym for V_$ENABLEDPRIVSSynonym for V_$FILESTATSynonym for V_$FIXED_TABLESyno
29、nym for V_$LATCHSynonym for V_$LATCHHOLDERSynonym for V_$LATCHNAMESynonym for V_$LIBRARYCACHESynonym for V_$LICENSESynonym for V_$LOADCSTATSynonym for V_$LOADTSTATSynonym for V_$LOCKSynonym for V_$LOGSynonym for V_$LOGFILESynonym for V_$LOGHISTSynonym for V_$LOG_HISTORYSynonym for V_$MLS_PARAMETERSS
30、ynonym for V_$MTSSynonym for V_$NLS_PARAMETERSSynonym for V_$NLS_VALID_VALUESSynonym for V_$OPEN_CURSORSynonym for V_$OPTIONSynonym for V_$PARAMETERSynonym for V_$PQ_SESSTATSynonym for V_$PQ_SLAVESynonym for V_$PQ_SYSSTATV$PROCESSV$QUEUEV$RECOVERY_LOGV$RECOVER_FILEV$REQDISTV$RESOURCEV$ROLLNAMEV$ROLL
31、STATV$ROWCACHEV$SESSIONV$SESSION_EVENTV$SESSION_WAITV$SESSTATV$SESS_IOV$SGAV$SGASTATV$SHARED_SERVERV$SQLAREAV$STATNAMEV$SYSSTATV$SYSTEM_CURSOR_CACHEV$SYSTEM_EVENTV$THREADV$TIMERV$TRANSACTIONV$TYPE_SIZEV$VERSIONV$WAITSTATV$_LOCKSynonym for V_$PROCESSSynonym for V_$QUEUESynonym for V_$RECOVERY_LOGSyno
32、nym for V_$RECOVER_FILESynonym for V_$REQDISTSynonym for V_$RESOURCESynonym for V_$ROLLNAMESynonym for V_$ROLLSTATSynonym for V_$ROWCACHESynonym for V_$SESSIONSynonym for V_$SESSION_EVENTSynonym for V_$SESSION_WAITSynonym for V_$SESSTATSynonym for V_$SESS_IOSynonym for V_$SGASynonym for V_$SGASTATSy
33、nonym for V_$SHARED_SERVERSynonym for V_$SQLAREASynonym for V_$STATNAMESynonym for V_$SYSSTATSynonym for V_$SYSTEM_CURSOR_CACHESynonym for V_$SYSTEM_EVENTSynonym for V_$THREADSynonym for V_$TIMERSynonym for V_$TRANSACTIONSynonym for V_$TYPE_SIZESynonym for V_$VERSIONSynonym for V_$WAITSTATSynonym for V_$_LOCKV$SESSION_CURSOR_CACHESynonym for V_$SESSION_CURSOR_CACHE