posts - 15, comments - 34, trackbacks - 27

以下表格中收集了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_CATALOG	All tables, views, synonyms, sequences accessible to the user
ALL_COL_COMMENTS	Comments on columns of accessible tables and views
ALL_COL_GRANTS_MADE	Grants on columns for which the user is owner or grantor
ALL_COL_GRANTS_RECD	Grants on columns for which the user or PUBLIC is the grantee
ALL_COL_PRIVS	Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_COL_PRIVS_MADE	Grants on columns for which the user is owner or grantor
ALL_COL_PRIVS_RECD	Grants on columns for which the user, PUBLIC or enabled role is the grantee
ALL_CONSTRAINTS	Constraint definitions on accessible tables
ALL_CONS_COLUMNS	Information about accessible columns in constraint definitions
ALL_DB_LINKS	Database links accessible to the user
ALL_DEF_AUDIT_OPTS	Auditing options for newly created objects
ALL_DEPENDENCIES	Dependencies to and from objects accessible to the user
ALL_ERRORS	Current errors on stored objects that user is allowed to create
ALL_INDEXES	Descriptions of indexes on tables accessible to the user
ALL_IND_COLUMNS	COLUMNs comprising INDEXes on accessible TABLES
ALL_OBJECTS	Objects accessible to the user
ALL_REFRESH	All the refresh groups that the user can touch
ALL_REFRESH_CHILDREN	All the objects in refresh groups, where the user can touch the group
ALL_SEQUENCES	Description of SEQUENCEs accessible to the user
ALL_SNAPSHOTS	Snapshots the user can look at
ALL_SOURCE	Current source on stored objects that user is allowed to create
ALL_SYNONYMS	All synonyms accessible to the user
ALL_TABLES	Description of tables accessible to the user
ALL_TAB_COLUMNS	Columns of all tables, views and clusters
ALL_TAB_COMMENTS	Comments on tables and views accessible to the user
ALL_TAB_GRANTS_MADE	User's grants and grants on user's objects
ALL_TAB_GRANTS_RECD	Grants on objects for which the user or PUBLIC is the grantee
ALL_TAB_PRIVS	Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADE	User's grants and grants on user's objects
ALL_TAB_PRIVS_RECD	Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TRIGGERS	Triggers accessible to the current user
ALL_TRIGGER_COLS	Column usage in user's triggers or in triggers on user's tables
ALL_USERS	Information about all users of the database
ALL_VIEWS	Text of views accessible to the user
USER_AUDIT_CONNECT	Audit trail entries for user logons/logoffs
USER_AUDIT_OBJECT	Audit 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_STATEMENT	Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER_AUDIT_TRAIL	Audit trail entries relevant to the user
USER_CATALOG	Tables, Views, Synonyms and Sequences owned by the user
USER_CLUSTERS	Descriptions of user's own clusters
USER_CLU_COLUMNS	Mapping of table columns to cluster columns
USER_COL_COMMENTS	Comments on columns of user's tables and views
USER_COL_GRANTS	Grants on columns for which the user is the owner, grantor or grantee
USER_COL_GRANTS_MADE	All grants on columns of objects owned by the user
USER_COL_GRANTS_RECD	Grants on columns for which the user is the grantee
USER_COL_PRIVS	Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE	All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD	Grants on columns for which the user is the grantee
USER_CONSTRAINTS	Constraint definitions on user's own tables
USER_CONS_COLUMNS	Information about accessible columns in constraint definitions
USER_CROSS_REFS	Cross references for user's views and synonyms
USER_DB_LINKS	Database links owned by the user
USER_DEPENDENCIES	Dependencies to and from a users objects
USER_ERRORS	Current errors on stored objects owned by the user
USER_EXTENTS	Extents comprising segments owned by the user
USER_FREE_SPACE	Free extents in tablespaces accessible to the user
USER_INDEXES	Description of the user's own indexes
USER_IND_COLUMNS	COLUMNs comprising user's INDEXes or on user's TABLES
USER_JOBS	All jobs owned by this user
USER_OBJECTS	Objects owned by the user
USER_OBJECT_SIZE	Sizes, in bytes, of various pl/sql objects
USER_OBJ_AUDIT_OPTS	Auditing options for user's own tables and views
USER_REFRESH	All the refresh groups
USER_REFRESH_CHILDREN	All the objects in refresh groups, where the user owns the refresh group
USER_RESOURCE_LIMITS	Display resource limit of the user
USER_ROLE_PRIVS	Roles granted to current user
USER_SEGMENTS	Storage allocated for all database segments
USER_SEQUENCES	Description of the user's own SEQUENCEs
USER_SNAPSHOTS	Snapshots the user can look at
USER_SNAPSHOT_LOGS	All snapshot logs owned by the user
USER_SOURCE	Source of stored objects accessible to the user
USER_SYNONYMS	The user's private synonyms
USER_SYS_PRIVS	System privileges granted to current user
USER_TABLES	Description of the user's own tables
USER_TABLESPACES	Description of accessible tablespaces
USER_TAB_AUDIT_OPTS	Auditing options for user's own tables and views
USER_TAB_COLUMNS	Columns of user's tables, views and clusters
USER_TAB_COMMENTS	Comments on the tables and views owned by the user
USER_TAB_GRANTS	Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_GRANTS_MADE	All grants on objects owned by the user
USER_TAB_GRANTS_RECD	Grants on objects for which the user is the grantee
USER_TAB_PRIVS	Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE	All grants on objects owned by the user
USER_TAB_PRIVS_RECD	Grants on objects for which the user is the grantee
USER_TRIGGERS	Triggers owned by the user
USER_TRIGGER_COLS	Column usage in user's triggers
USER_TS_QUOTAS	Tablespace quotas for the user
USER_USERS	Information about the current user
USER_VIEWS	Text of views owned by the user
AUDIT_ACTIONS	Description table for audit trail action type codes. Maps action type numbers to action type names
COLUMN_PRIVILEGES	Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
DICTIONARY	Description of data dictionary tables and views
DICT_COLUMNS	Description of columns in data dictionary tables and views
DUAL
GLOBAL_NAME	global database name
INDEX_HISTOGRAM	statistics on keys with repeat count
INDEX_STATS	statistics on the b-tree
RESOURCE_COST	Cost for each resource
ROLE_ROLE_PRIVS	Roles which are granted to roles
ROLE_SYS_PRIVS	System privileges granted to roles
ROLE_TAB_PRIVS	Table privileges granted to roles
SESSION_PRIVS	Privileges which the user currently has set
SESSION_ROLES	Roles which the user currently has enabled.
TABLE_PRIVILEGES	Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ACCESSIBLE_COLUMNS	Synonym for ALL_TAB_COLUMNS
ALL_COL_GRANTS	Synonym for COLUMN_PRIVILEGES
ALL_JOBS	Synonym for USER_JOBS
ALL_TAB_GRANTS	Synonym for TABLE_PRIVILEGES
CAT	Synonym for USER_CATALOG
CLU	Synonym for USER_CLUSTERS
COLS	Synonym for USER_TAB_COLUMNS
DBA_AUDIT_CONNECT	Synonym for USER_AUDIT_CONNECT
DBA_AUDIT_RESOURCE	Synonym for USER_AUDIT_RESOURCE
DBA_REFRESH_CHILDREN	Synonym for USER_REFRESH_CHILDREN
DICT	Synonym for DICTIONARY
IND	Synonym for USER_INDEXES
OBJ	Synonym for USER_OBJECTS
SEQ	Synonym for USER_SEQUENCES
SM$VERSION	Synonym for SM_$VERSION
SYN	Synonym for USER_SYNONYMS
TABS	Synonym for USER_TABLES
V$ACCESS	Synonym for V_$ACCESS
V$ARCHIVE	Synonym for V_$ARCHIVE
V$BACKUP	Synonym for V_$BACKUP
V$BGPROCESS	Synonym for V_$BGPROCESS
V$CIRCUIT	Synonym for V_$CIRCUIT
V$COMPATIBILITY	Synonym for V_$COMPATIBILITY
V$COMPATSEG	Synonym for V_$COMPATSEG
V$CONTROLFILE	Synonym for V_$CONTROLFILE
V$DATABASE	Synonym for V_$DATABASE
V$DATAFILE	Synonym for V_$DATAFILE
V$DBFILE	Synonym for V_$DBFILE
V$DBLINK	Synonym for V_$DBLINK
V$DB_OBJECT_CACHE	Synonym for V_$DB_OBJECT_CACHE
V$DISPATCHER	Synonym for V_$DISPATCHER
V$ENABLEDPRIVS	Synonym for V_$ENABLEDPRIVS
V$FILESTAT	Synonym for V_$FILESTAT
V$FIXED_TABLE	Synonym for V_$FIXED_TABLE
V$LATCH	Synonym for V_$LATCH
V$LATCHHOLDER	Synonym for V_$LATCHHOLDER
V$LATCHNAME	Synonym for V_$LATCHNAME
V$LIBRARYCACHE	Synonym for V_$LIBRARYCACHE
V$LICENSE	Synonym for V_$LICENSE
V$LOADCSTAT	Synonym for V_$LOADCSTAT
V$LOADTSTAT	Synonym for V_$LOADTSTAT
V$LOCK	Synonym for V_$LOCK
V$LOG	Synonym for V_$LOG
V$LOGFILE	Synonym for V_$LOGFILE
V$LOGHIST	Synonym for V_$LOGHIST
V$LOG_HISTORY	Synonym for V_$LOG_HISTORY
V$MLS_PARAMETERS	Synonym for V_$MLS_PARAMETERS
V$MTS	Synonym for V_$MTS
V$NLS_PARAMETERS	Synonym for V_$NLS_PARAMETERS
V$NLS_VALID_VALUES	Synonym 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_SYSSTAT	Synonym for V_$PQ_SYSSTAT
V$PROCESS	Synonym for V_$PROCESS
V$QUEUE	Synonym for V_$QUEUE
V$RECOVERY_LOG	Synonym for V_$RECOVERY_LOG
V$RECOVER_FILE	Synonym for V_$RECOVER_FILE
V$REQDIST	Synonym for V_$REQDIST
V$RESOURCE	Synonym for V_$RESOURCE
V$ROLLNAME	Synonym for V_$ROLLNAME
V$ROLLSTAT	Synonym for V_$ROLLSTAT
V$ROWCACHE	Synonym for V_$ROWCACHE
V$SESSION	Synonym for V_$SESSION
V$SESSION_CURSOR_CACHE	Synonym for V_$SESSION_CURSOR_CACHE
V$SESSION_EVENT	Synonym for V_$SESSION_EVENT
V$SESSION_WAIT	Synonym for V_$SESSION_WAIT
V$SESSTAT	Synonym for V_$SESSTAT
V$SESS_IO	Synonym for V_$SESS_IO
V$SGA	Synonym for V_$SGA
V$SGASTAT	Synonym for V_$SGASTAT
V$SHARED_SERVER	Synonym for V_$SHARED_SERVER
V$SQLAREA	Synonym for V_$SQLAREA
V$STATNAME	Synonym for V_$STATNAME
V$SYSSTAT	Synonym for V_$SYSSTAT
V$SYSTEM_CURSOR_CACHE	Synonym for V_$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT	Synonym for V_$SYSTEM_EVENT
V$THREAD	Synonym for V_$THREAD
V$TIMER	Synonym for V_$TIMER
V$TRANSACTION	Synonym for V_$TRANSACTION
V$TYPE_SIZE	Synonym for V_$TYPE_SIZE
V$VERSION	Synonym for V_$VERSION
V$WAITSTAT	Synonym for V_$WAITSTAT
V$_LOCK	Synonym for V_$_LOCK

本文引用通告地址： http://blog.csdn.net/jwbecalm/services/trackbacks/424696.aspx

posted on 2005-08-28 05:23 jacky 閱讀(552) 評論(1) 編輯收藏

FeedBack:

# re: Oracle常用數據字典

2010-06-18 11:28 | lacewigs

definitely enjoying every little bit of it.It is a great website and nice share.I want to thank you.Good job! You guys do a great blog, and have some great contents. 回復更多評論

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理

2005年8月

日

一

二

三

四

五

六

常用鏈接

留言簿(10)

隨筆檔案

文章分類

文章檔案

相冊

2005
images

收藏夾

java

dev.java.net
ebook
Java 與系統安全
Java 平臺的基本語言和庫擴展都提供了用于編寫安全應用程序的極佳基礎。本教程討論了密碼術基礎知識與如何用Java 編程語言實現密碼術，并提供了樣本代碼來說明這些概念。
osworkflow
OSWorkflow - Running the Example App
osworkflow API
Osworkflow 中文教程
中國工作流論壇
工作流專題
我應該采用哪一種 WSDL 樣式
WSDL 綁定樣式可以是 RPC 樣式或文檔樣式。用法可以是編碼的，也可以是文字的。 RPC/編碼 RPC/文字文檔/編碼文檔/文字您如何決定使用哪一種樣式/用法的組合呢？本文將幫助您解決這個問題。
跨平臺DHTML＋Javascript類庫