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 |
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/82387/viewspace-1019370/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle常用的資料字典Oracle
- Oracle常用資料字典表Oracle
- oracle常用資料字典.檢視Oracle
- ORACLE常用資料字典介紹Oracle
- Oracle中的資料字典技術及常用資料字典總結Oracle
- 工作中 Oracle 常用資料字典集錦Oracle
- oracle10g 常用資料字典總結Oracle
- (轉)Oracle常用資料字典查詢語句Oracle
- Oracle 常用資料字典表、檢視的總結Oracle
- oracle10g 常用資料字典總結 (zt)Oracle
- Oracle 常用資料字典檢視、表的總結Oracle
- oracle 資料字典Oracle
- Oracle 資料字典和資料字典檢視Oracle
- oracle 資料字典（轉）Oracle
- Oracle資料字典 (轉)Oracle
- 生成oracle資料字典Oracle
- Oracle 資料字典 (轉)Oracle
- Oracle的資料字典Oracle
- Oracle 資料字典學習Oracle
- Oracle 資料字典大全 ZTOracle
- oracle資料字典簡介Oracle
- 瞭解Oracle資料字典Oracle
- ORACLE使用者常用資料字典的查詢使用方法Oracle
- oracle資料庫資料字典應用Oracle資料庫
- DBA常用的資料字典檢視（一）
- 常用的資料字典檢視和包
- ORACLE-使用者常用資料字典的查詢使用方法Oracle
- ORACLE使用者常用資料字典的查詢使用方法(轉)Oracle
- oracle結構梳理---資料字典Oracle
- oracle 資料字典關係圖Oracle
- Oracle的4類資料字典Oracle
- 深入瞭解Oracle資料字典Oracle
- oracle實驗記錄 (oracle 資料字典)Oracle
- 什麼是Oracle的資料字典？Oracle
- Oracle相關資料字典檢視Oracle
- 【轉載】Oracle資料字典檢視Oracle
- 深入瞭解Oracle資料字典(zt)Oracle
- Oracle資料字典的用途介紹Oracle