Oracle数据字典

以下表格中收集了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