Oracle common data dictionary

xiaoxiao2021-03-06  103

Almost all views or alias in the Oracle data dictionary are collected in the following table, as for each view or alias field, use the 'DESCRIBE' statement to query.

Name description:

In the Oracle Data Dictionary, the object name is mostly "user.", "All.", "DBA." Is the prefix "user." View, record the objects of the object you have in the account that typically records the account, "all." View Include information including "user" record and authorization to public or user, "DBA." View contains all database objects, regardless of their owner.

Example:

SELECT * FROM DBA_DATA_FILES

Query the information of the table space (the current user must have a DBA role).

Select Owner, Object_name, Object_Type from All_Objects

Check all the tables, processes, functions such as a certain user.

View Name Description ALL_CATALOGAll tables, views, synonyms, sequences accessible to the user ALL_COL_COMMENTSComments on columns of accessible tables and views ALL_COL_GRANTS_MADEGrants on the grantee ALL_COL_PRIVSGrants on columns for which columns for which the user is owner or grantorALL_COL_GRANTS_RECDGrants on columns for which the user or PUBLIC is 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 grantorALL_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_IND EXESDescriptions 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, Re voke, 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 TABLESUSER_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 oowned 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 granto R, 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_ $ DATAFI LE 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_PARA

转载请注明原文地址:https://www.9cbs.com/read-126888.html

New Post(0)