视图名
|
描述
|
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 表的列详情: USER_TAB_COLUMNS
|
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 用户具有的系统权限(查询出来的列admin_option,如果该列的值是YES,表示此权限此用户可以继续往外派生,赋予)
|
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_ROL_PRIVS
|
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 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典Oracle 数据字典
介绍Oracle 数据字典,常用的数据字典表
Oracle数据字典.pdf ) Oracle数据字典.pdf ) Oracle数据字典.pdf )
oracle数据字典制作流程
里面有教学系统的oracle数据字典。同时插入了数据,当学习oracle时,可以利用里面的数据来进行数据操作。
Oracle数据字典参考Oracle数据字典参考Oracle数据字典参考Oracle数据字典参考Oracle数据字典参考
ORACLE数据字典与视图
华为公司详细的Oracle数据字典,里面包含有非常详细的数据字典及中文说明,另附有CHM版的Oracle工具资料,非常不错,是学习Oracle应用的好东西。推荐。
oracle导出excel的数据字典sql,根据该sql可以导出数据字典。
学习Oralce基本资料 Oracle数据字典 学习Oralce基本资料 Oracle数据字典 学习Oralce基本资料 Oracle数据字典
首先,Oracle的字典表和视图基本上可以分为三个层次。 1.1 X$表 这一部分表是Oracle数据库的运行基础,在数据库启动时由Oracle应用程序动态创建。 这部分表对数据库来说至关重要,所以Oracle不允许SYSDBA之外的用户...
数据字典生成工具,用于生成 数据库表 及字段说明,主要特征如下: 1、支持的数据库类型:SQL Server 2005+,My SQL,Oracle; 2、支持的文档类型:HTML,CHM,WORD; 3、基于Open XML ,不用安装 MS Office,WPS 也可以生产...
了解Oracle数据字典 ODBC 数据字典(data dictionary)是存储在数据库中的所有对象信息的知识库。Oracle RDBMS使用数据字典获取对象信息和安全信息,而用户和DBA用它来查阅数据库信息。数据字典是只读的,终端用户...
NULL 博文链接:https://snowelf.iteye.com/blog/2004244
Oracle数据字典.ppt
oracle 导出数据字典的小工具 能导成word形式的带表格的数据字典,非常好用从网上转载的
强大的 mysql/oracle数据字典生成工具 ,根据 sql 文件,直接生成 word 文件,表格以及格式全部生成好,非常规范整洁,超级值,收藏备用,参考都可以。不可错过的好东西。
MYSQL/ORACLE数据字典生成器 破解版 觉得还不错 可以生成WORLD文档 也可以转化成CHM格式的