Oracle 数据字典

宏哥 发布于 2011/05/23 11:16
阅读 290
收藏 4

以下表格中收集了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

 

加载中
返回顶部
顶部