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 |
相关推荐
常用的 Oracle 数据字典包括: 1. DBA_OBJECTS:该数据字典包含了关于数据库对象的基本信息,如对象名称、对象类型、所有者、创建时间等。 2. DBA_TABLES:该数据字典包含了关于数据库表的信息,如表名称、表空间、...
Oracle数据库是世界上广泛使用的商业关系型数据库管理系统之一,它提供了丰富的数据字典视图以及动态性能视图,供数据库管理员(DBA)进行监控和管理。数据字典是Oracle数据库的系统表空间中的一组表和视图,记录了...
### Oracle常用数据字典表及动态视图 在Oracle数据库管理中,理解并掌握数据字典表和动态性能视图是非常重要的。它们提供了关于数据库结构、配置和运行时状态的关键信息。本文将详细介绍Oracle中的一些常用数据字典...
数据字典视图说明: 数据字典视图一般有三套:以存表的视图为例 dba_tables[DBA所有的], all_tables[所有用户所有的], user_tables[当前用户所有的] 对于DBA所有的,只有拥有DBA权限的用户才可以查询,否则提示表或...
数据字典视图说明: 数据字典视图一般有三套:以存表的视图为例 dba_tables[DBA所有的], all_tables[所有用户所有的], user_tables[当前用户所有的] 对于DBA所有的,只有拥有DBA权限的用户才可以查询,否则提示表或...
Oracle 数据字典是数据库管理系统中的一个关键组成部分,它包含了关于数据库对象、权限、索引、约束等信息的元数据。这些信息对于数据库管理员和开发人员来说至关重要,因为它们提供了对数据库结构和状态的深入理解...
Oracle EBS中文数据字典.pdf
在Oracle数据库管理与维护中,理解并掌握数据字典的使用是至关重要的。数据字典是一种特殊的表集合,用于存储数据库自身的元数据信息,包括数据库结构、对象定义、权限分配等。以下是从“Oracle中常用数据字典大总结...
### ORACLE用户常用数据字典的查询使用方法 在Oracle数据库管理中,了解并掌握如何查询数据字典是非常重要的技能之一。数据字典是数据库系统内部用来存储有关数据库元数据(即描述数据的数据)的表格集合。对于...
### Oracle EBS 数据字典中文版 #### 一、OE模块 **1. 表名**: ONT.OE_order_headers_all **说明**: 订单头信息表存储了所有销售订单的基本信息,包括订单编号、创建日期、状态等关键字段。这对于理解和追踪销售...
Oracle 数据库常用数据字典梳理 Oracle 数据库管理系统中,数据字典是一个核心组件,用于存储数据库对象的元数据,如表、索引、视图、存储过程等。数据字典的字段定义可以分为两大类:静态视图和动态视图。 静态...
### 从Oracle生成表的数据字典方法 在Oracle数据库管理中,数据字典是一个非常重要的工具,它能够帮助我们理解数据库结构、表定义以及列属性等详细信息。本篇文章将介绍如何从Oracle数据库中利用COMMENT生成Excel...
数据字典和动态性能视图在Oracle数据库管理中扮演着至关重要的角色,它们为数据库管理员提供了丰富的信息资源,帮助理解数据库的状态和行为。 数据字典是Oracle数据库的核心组成部分,它是一组只读的表和视图,由...
以下是一些常用的数据字典查询示例,旨在帮助Oracle用户更好地利用这一宝贵资源: #### 1. 用户信息 - **查看当前用户的缺省表空间**:`SELECT username, default_tablespace FROM user_users;` - **查看当前用户...
### ORACLE完整数据字典详解 #### 一、概述 Oracle 数据库系统是业界领先的数据库管理系统之一,提供了强大而全面的数据管理功能。...本文介绍了一些常用的数据字典表及其字段,希望对读者有所帮助。
#### 三、DBA常用数据字典表 除了上述基础表外,Oracle还提供了一系列以`dba_`、`user_`和`v$`开头的表和视图,专为数据库管理员(DBA)设计,用于监控和管理数据库。 ##### 1. DBA常用表(`dba_`开头) - `dba_...
### Oracle常用数据字典表详解 #### 一、Oracle用户数据字典介绍 在Oracle数据库中,用户数据字典提供了一系列视图,用于查询数据库对象的相关信息,包括但不限于表、索引、序列等。这些视图对理解数据库结构、...