Oracle Common Data Dictionary

oracle| Data Author: anon Source: InterNet Add Time: 2003-7-20
The following table collects almost all the views or aliases in the Oracle data dictionary, and for each view or alias field, use the ' Describe ' statement to query.

Name Description:

In the Oracle data dictionary, the object names are mostly "USER.", "all.", "DBA." is the prefix "USER." The view records information that typically records the objects owned by the account that executes the query, "all." The view records information that includes "USER" records and authorization to public or user objects, "DBA." The view contains all database objects, regardless of their owner.

Use examples:

SELECT * FROM Dba_data_files

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

Select owner, object_name, object_type from All_objects

Query for information about all tables, procedures, functions, etc. under a user.


View Name

Describe
All_catalogall tables, views, synonyms, sequences accessible to the user all_col_commentscomments on columns of of accessible Tables and views all_col_grants_madegrants on columns for which the user's owner or grantorall_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, gran Tee, owner, or the grantee all_col_privs_madegrants on columns for which to the user is owner or Grantorall_col_privs_recdgrants on columns to which the user, public or enabled to is the grantee All_constraintsconst Raint definitions on accessible tables all_cons_columnsinformation about accessible columns in constraint definitions All_ Db_linksdatabase links accessible to "user all_def_audit_optsauditing options for newly created objects All_dependencie Sdependencies to and from objects accessible to the user all_errorscurrent errors on stored objects This user is allowed T o Create All_indexesdescRiptions of indexes on tables accessible to the user All_ind_columnscolumns comprising indexes on accessible tables All_ob Jectsobjects accessible to the user All_refreshall the refresh groups this 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 in all_sourcecurrent source on stored objects This 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 in tables and views accessible to the user All_tab_grants_made User ' s grants and grants on user's objects all_tab_grants_recdgrants on objects for which the user or public is the Grante e all_tab_privsgrants on objects to which the user is the grantor, grantee, owner, or the GR Antee 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 t Riggers on user's tables all_usersinformation about all users of the "database All_viewstext of views accessible to" use R User_audit_connectaudit Trail entries for USER logons/logoffs User_audit_objectaudit Trail Records for statements Concer Ning objects, specifically:table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, tr Igger, rollback segment, tablespace, role, user User_audit_session User_audit_statementaudit Trail Records concerning GRA NT, revoke, audit, Noaudit and alter system User_audit_trailaudit trail entries relevant to the USER User_catalogtables, V Iews, 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 to USER ' s tables and views user_col_grantsgrants on columns for which the US Er 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 from the USER user_col_privs_recdgrants on Colu MNS for which the user's grantee user_constraintsconstraint definitions on user ' s own tables User_cons_columnsinforma tion about accessible columns in constraint definitions User_cross_refscross the for user's views and references user _db_linksdatabase links owned by the user user_dependenciesdependencies to and from a users objects user_errorscurrent err ORS on stored objects owned by the user user_extentsextents comprising segments owned by the user User_free_spacefree NTS in tablespaces accesSible to the user user_indexesdescription of the user ' s own indexes user_ind_columnscolumns comprising user ' s indexes or O N 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_limits Display resource limit of the user User_role_privsroles granted to current user User_segmentsstorage allocated for all DAT Abase segments user_sequencesdescription of the user ' s own sequences user_snapshotssnapshots the user can look at User_sna Pshot_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 t Ables USER_TABLESPACESDEScription of accessible tablespaces user_tab_audit_optsauditing options for USER ' s own tables and views User_tab_columnsco Lumns of user ' s tables, views and clusters user_tab_commentscomments on the tables and views owned by the user User_tab_gr Antsgrants on objects for which "user is" owner, grantor or grantee user_tab_grants_madeall grants on objects By the user user_tab_grants_recdgrants on objects for which the "user is" the grantee user_tab_privsgrants on objects for WH Ich the user is the owner, grantor or grantee User_tab_privs_madeall grants on objects owned by the user User_tab_privs_re Cdgrants on objects for which the user's the grantee user_triggerstriggers owned by the user User_trigger_colscolumn E in user's triggers user_ts_quotastablespace quotas for the "user user_usersinformation about the current user User_viewst Ext 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 to which the user is the grantor, grantee, owner, or a enabled role or public is the GRA Ntee dictionarydescription of data dictionary tables and views dict_columnsdescription the columns in data dictionary table S 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 PR Ivileges 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 to which the user is the grantor, grantee, owner, or a enabled role or public is the G Rantee accessible_columnssynonym for All_tab_columns all_col_grantssynonym to Column_privileges for User_jobs all_tab_grantssynonym for table_privileges catsynonym for User_catalog CLUSynonym 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 for sm$versionsynonym $VERSION synsynonym for user_synonyms tabssynonym for user_tables v$accesssynonym for v_$access v$archivesynonym for V_$AR Chive v$backupsynonym for V_$backup v$bgprocesssynonym for v_$bgprocess v$circuitsynonym for V_$CIRCUIT 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_$D BLINK v$db_object_cachesynonym for V_$db_object_cache v$dispatchersynonym to V_$dispatcher for V _$enabledprivs v$filestatsynonym for V_$filestat v$fixed_tablesYnonym for v_$fixed_table v$latchsynonym for V_$latch v$latchholdersynonym to V_$latchholder for V$LATCHNAMESynonym Atchname v$librarycachesynonym for V_$librarycache v$licensesynonym for V_$license v$loadcstatsynonym for V_$LOADCSTAT V $LOADTSTATSynonym for V_$loadtstat v$locksynonym to V_$lock v$logsynonym for V_$log v$logfilesynonym for V_$logfile Histsynonym 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 to v_$option v$parameter synonym for V_$parameter V$PQ_SESSTAT S ynonym for v_$pq_sesstat v$pq_slave synonym for V_$pq_slave v$pq_sysstatsynonym for V_$pq_sysstat for V$PROCESSSynonym 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 to V_$rollstat for V$ROWCACHESynonym 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 to V_$sgastat for v$shared_serversynonym VER v$sqlareasynonym for V_$sqlarea v$statnamesynonym for V_$statname v$sysstatsynonym for V_$sysstat 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