刘慈欣谈ChatGPT：人类的无能反而 刘慈欣谈ChatGPT：人类的无能反而
OpenAI 因使用“窃取”的个人数据 OpenAI 因使用“窃取”的个人数据
搜狐回应员工遭遇工资补助诈骗： 搜狐回应员工遭遇工资补助诈骗：

软件测试 > 测试开发技术 > 软件测试开发语言 > 数据库 >

Oracle常用数据字典

发表于：2007-06-07来源：作者：点击数： 标签：
以下表格中收集了 Oracle 数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用Describe语句来查询。 命名说明： Oracle数据字典中，对象名称多数以USER.，ALL.，DBA.为前缀USER.视图中记录通常记录执行查询的帐户所拥有的对象的信息，ALL.视图中

         以下表格中收集了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 aclearcase/" target="_blank" >ccessible 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 grantor
ALL_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 grantor
ALL_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_SESSION　
USER_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 TABLES
USER_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
DUAL　
GLOBAL_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


原文转自：http://www.ltesting.net

相关文章

软件测试沙龙 More>>

新浪微博More>>

...

热门标签