Oracle的数据字典

  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