Oracle常用数据字典.pdf

OracleOracle 常用数据字典常用数据字典http:/ 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_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_REFRESHuser描述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 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 the 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 userAll 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_CONNECTUSER_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 the 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 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 userAudit 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_CATALOGUSER_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 users 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 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_REFRESH_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_PRIVS_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 userDependencies 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 owned 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 segmentsDescription 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 options 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 objects 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_SYS_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 in 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 PUBLIC 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 privileges 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_JOBSSynonym 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 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$LOADTSTATV$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_$CIRCUITSynonym 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_TABLESynonym 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_PARAMETERSSynonym 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$ROLLSTATV$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_LOGSynonym 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_$SGASTATSynonym 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