分享
 
 
 

Oracle数据字典

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有