作者：佚名 来源：internet 加入时间：2003-7-20
以下表格中收集了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 accessible 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 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, 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_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 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 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
