oracle常用数据字典.docx

oracle常用数据字典.docx

《oracle常用数据字典.docx》由会员分享，可在线阅读，更多相关《oracle常用数据字典.docx（29页珍藏版）》请在冰豆网上搜索。

oracle常用数据字典

　以下表格中收集了Oracle数据字典中几乎所有的视图或别名，至于每个视图或别名的字段请用‘Describe’语句来查询。

　　命名说明：

　　Oracle数据字典中，对象名称多数以"USER."，"ALL."，"DBA."为前缀"USER."视图中记录通常记录执行查询的帐户所拥有的对象的信息，"ALL."视图中记录包括"USER"记录和授权至PUBLIC或用户的对象的信息，"DBA."视图包含所有数据库对象，而不管其所有者。

　　使用举例：

　　select*fromdba_data_files

　　查询表空间的信息（当前用户必须拥有DBA角色）。

　　selectowner,object_name,object_typefromall_objects

　　查询某一用户下的所有表、过程、函数等信息。

视图名

描述

ALL_CATALOG

Alltables,views,synonyms,sequencesaccessibletotheuser

ALL_COL_COMMENTS

Commentsoncolumnsofaccessibletablesandviews

ALL_COL_GRANTS_MADE

Grantsoncolumnsforwhichtheuserisownerorgrantor

ALL_COL_GRANTS_RECD

GrantsoncolumnsforwhichtheuserorPUBLICisthegrantee

ALL_COL_PRIVS

Grantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ALL_COL_PRIVS_MADE

Grantsoncolumnsforwhichtheuserisownerorgrantor

ALL_COL_PRIVS_RECD

Grantsoncolumnsforwhichtheuser,PUBLICorenabledroleisthegrantee

ALL_CONSTRAINTS

Constraintdefinitionsonaccessibletables

ALL_CONS_COLUMNS

Informationaboutaccessiblecolumnsinconstraintdefinitions

ALL_DB_LINKS

Databaselinksaccessibletotheuser

ALL_DEF_AUDIT_OPTS

Auditingoptionsfornewlycreatedobjects

ALL_DEPENDENCIES

Dependenciestoandfromobjectsaccessibletotheuser

ALL_ERRORS

Currenterrorsonstoredobjectsthatuserisallowedtocreate

ALL_INDEXES

Descriptionsofindexesontablesaccessibletotheuser

ALL_IND_COLUMNS

COLUMNscomprisingINDEXesonaccessibleTABLES

ALL_OBJECTS

Objectsaccessibletotheuser

ALL_REFRESH

Alltherefreshgroupsthattheusercantouch

ALL_REFRESH_CHILDREN

Alltheobjectsinrefreshgroups,wheretheusercantouchthegroup

ALL_SEQUENCES

DescriptionofSEQUENCEsaccessibletotheuser

ALL_SNAPSHOTS

Snapshotstheusercanlookat

ALL_SOURCE

Currentsourceonstoredobjectsthatuserisallowedtocreate

ALL_SYNONYMS

Allsynonymsaccessibletotheuser

ALL_TABLES

Descriptionoftablesaccessibletotheuser

ALL_TAB_COLUMNS

Columnsofalltables,viewsandclusters

ALL_TAB_COMMENTS

Commentsontablesandviewsaccessibletotheuser

ALL_TAB_GRANTS_MADE

User'sgrantsandgrantsonuser'sobjects

ALL_TAB_GRANTS_RECD

GrantsonobjectsforwhichtheuserorPUBLICisthegrantee

ALL_TAB_PRIVS

Grantsonobjectsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ALL_TAB_PRIVS_MADE

User'sgrantsandgrantsonuser'sobjects

ALL_TAB_PRIVS_RECD

Grantsonobjectsforwhichtheuser,PUBLICorenabledroleisthegrantee

ALL_TRIGGERS

Triggersaccessibletothecurrentuser

ALL_TRIGGER_COLS

Columnusageinuser'striggersorintriggersonuser'stables

ALL_USERS

Informationaboutallusersofthedatabase

ALL_VIEWS

Textofviewsaccessibletotheuser

USER_AUDIT_CONNECT

Audittrailentriesforuserlogons/logoffs

USER_AUDIT_OBJECT

Audittrailrecordsforstatementsconcerningobjects,specifically:

table,cluster,view,index,sequence,[public]databaselink,[public]synonym,procedure,trigger,rollbacksegment,tablespace,role,user

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

Audittrailrecordsconcerninggrant,revoke,audit,noauditandaltersystem

USER_AUDIT_TRAIL

Audittrailentriesrelevanttotheuser

USER_CATALOG

Tables,Views,SynonymsandSequencesownedbytheuser

USER_CLUSTERS

Descriptionsofuser'sownclusters

USER_CLU_COLUMNS

Mappingoftablecolumnstoclustercolumns

USER_COL_COMMENTS

Commentsoncolumnsofuser'stablesandviews

USER_COL_GRANTS

Grantsoncolumnsforwhichtheuseristheowner,grantororgrantee

USER_COL_GRANTS_MADE

Allgrantsoncolumnsofobjectsownedbytheuser

USER_COL_GRANTS_RECD

Grantsoncolumnsforwhichtheuseristhegrantee

USER_COL_PRIVS

Grantsoncolumnsforwhichtheuseristheowner,grantororgrantee

USER_COL_PRIVS_MADE

Allgrantsoncolumnsofobjectsownedbytheuser

USER_COL_PRIVS_RECD

Grantsoncolumnsforwhichtheuseristhegrantee

USER_CONSTRAINTS

Constraintdefinitionsonuser'sowntables

USER_CONS_COLUMNS

Informationaboutaccessiblecolumnsinconstraintdefinitions

USER_CROSS_REFS

Crossreferencesforuser'sviewsandsynonyms

USER_DB_LINKS

Databaselinksownedbytheuser

USER_DEPENDENCIES

Dependenciestoandfromausersobjects

USER_ERRORS

Currenterrorsonstoredobjectsownedbytheuser

USER_EXTENTS

Extentscomprisingsegmentsownedbytheuser

USER_FREE_SPACE

Freeextentsintablespacesaccessibletotheuser

USER_INDEXES

Descriptionoftheuser'sownindexes

USER_IND_COLUMNS

COLUMNscomprisinguser'sINDEXesoronuser'sTABLES

USER_JOBS

Alljobsownedbythisuser

USER_OBJECTS

Objectsownedbytheuser

USER_OBJECT_SIZE

Sizes,inbytes,ofvariouspl/sqlobjects

USER_OBJ_AUDIT_OPTS

Auditingoptionsforuser'sowntablesandviews

USER_REFRESH

Alltherefreshgroups

USER_REFRESH_CHILDREN

Alltheobjectsinrefreshgroups,wheretheuserownstherefreshgroup

USER_RESOURCE_LIMITS

Displayresourcelimitoftheuser

USER_ROLE_PRIVS

Rolesgrantedtocurrentuser

USER_SEGMENTS

Storageallocatedforalldatabasesegments

USER_SEQUENCES

Descriptionoftheuser'sownSEQUENCEs

USER_SNAPSHOTS

Snapshotstheusercanlookat

USER_SNAPSHOT_LOGS

Allsnapshotlogsownedbytheuser

USER_SOURCE

Sourceofstoredobjectsaccessibletotheuser

USER_SYNONYMS

Theuser'sprivatesynonyms

USER_SYS_PRIVS

Systemprivilegesgrantedtocurrentuser

USER_TABLES

Descriptionoftheuser'sowntables

USER_TABLESPACES

Descriptionofaccessibletablespaces

USER_TAB_AUDIT_OPTS

Auditingoptionsforuser'sowntablesandviews

USER_TAB_COLUMNS

Columnsofuser'stables,viewsandclusters

USER_TAB_COMMENTS

Commentsonthetablesandviewsownedbytheuser

USER_TAB_GRANTS

Grantsonobjectsforwhichtheuseristheowner,grantororgrantee

USER_TAB_GRANTS_MADE

Allgrantsonobjectsownedbytheuser

USER_TAB_GRANTS_RECD

Grantsonobjectsforwhichtheuseristhegrantee

USER_TAB_PRIVS

Grantsonobjectsforwhichtheuseristheowner,grantororgrantee

USER_TAB_PRIVS_MADE

Allgrantsonobjectsownedbytheuser

USER_TAB_PRIVS_RECD

Grantsonobjectsforwhichtheuseristhegrantee

USER_TRIGGERS

Triggersownedbytheuser

USER_TRIGGER_COLS

Columnusageinuser'striggers

USER_TS_QUOTAS

Tablespacequotasfortheuser

USER_USERS

Informationaboutthecurrentuser

USER_VIEWS

Textofviewsownedbytheuser

AUDIT_ACTIONS

Descriptiontableforaudittrailactiontypecodes.Mapsactiontypenumberstoactiontypenames

COLUMN_PRIVILEGES

Grantsoncolumnsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

DICTIONARY

Descriptionofdatadictionarytablesandviews

DICT_COLUMNS

Descriptionofcolumnsindatadictionarytablesandviews

DUAL

GLOBAL_NAME

globaldatabasename

INDEX_HISTOGRAM

statisticsonkeyswithrepeatcount

INDEX_STATS

statisticsontheb-tree

RESOURCE_COST

Costforeachresource

ROLE_ROLE_PRIVS

Roleswhicharegrantedtoroles

ROLE_SYS_PRIVS

Systemprivilegesgrantedtoroles

ROLE_TAB_PRIVS

Tableprivilegesgrantedtoroles

SESSION_PRIVS

Privilegeswhichtheusercurrentlyhasset

SESSION_ROLES

Roleswhichtheusercurrentlyhasenabled.

TABLE_PRIVILEGES

Grantsonobjectsforwhichtheuseristhegrantor,grantee,owner,oranenabledroleorPUBLICisthegrantee

ACCESSIBLE_COLUMNS

SynonymforALL_TAB_COLUMNS

ALL_COL_GRANTS

SynonymforCOLUMN_PRIVILEGES

ALL_JOBS

SynonymforUSER_JOBS

ALL_TAB_GRANTS

SynonymforTABLE_PRIVILEGES

CAT

SynonymforUSER_CATALOG

CLU

SynonymforUSER_CLUSTERS

COLS

SynonymforUSER_TAB_COLUMNS

DBA_AUDIT_CONNECT

SynonymforUSER_AUDIT_CONNECT

DBA_AUDIT_RESOURCE

SynonymforUSER_AUDIT_RESOURCE

DBA_REFRESH_CHILDREN

SynonymforUSER_REFRESH_CHILDREN

DICT

SynonymforDICTIONARY

IND

SynonymforUSER_INDEXES

OBJ

SynonymforUSER_OBJECTS

SEQ

SynonymforUSER_SEQUENCES

SM$VERSION

SynonymforSM_$VERSION

SYN

SynonymforUSER_SYNONYMS

TABS

SynonymforUSER_TABLES

V$ACCESS

SynonymforV_$ACCESS

V$ARCHIVE

SynonymforV_$ARCHIVE

V$BACKUP

SynonymforV_$BACKUP

V$BGPROCESS

SynonymforV_$BGPROCESS

V$CIRCUIT

SynonymforV_$CIRCUIT

V$COMPATIBILITY

SynonymforV_$COMPATIBILITY

V$COMPATSEG

SynonymforV_$COMPATSEG

V$CONTROLFILE

SynonymforV_$CONTROLFILE

V$DATABASE

SynonymforV_$DATABASE

V$DATAFILE

SynonymforV_$DATAFILE

V$DBFILE

SynonymforV_$DBFILE

V$DBLINK

SynonymforV_$DBLINK

V$DB_OBJECT_CACHE

SynonymforV_$DB_OBJECT_CACHE

V$DISPATCHER

SynonymforV_$DISPATCHER

V$ENABLEDPRIVS

SynonymforV_$ENABLEDPRIVS

V$FILESTAT

SynonymforV_$FILESTAT

V$FIXED_TABLE

SynonymforV_$FIXED_TABLE

V$LATCH

SynonymforV_$LATCH

V$LATCHHOLDER

SynonymforV_$LATCHHOLDER

V$LATCHNAME

SynonymforV_$LATCHNAME

V$LIBRARYCACHE

SynonymforV_$LIBRARYCACHE

V$LICENSE

SynonymforV_$LICENSE

V$LOADCSTAT

SynonymforV_$LOADCSTAT

V$LOADTSTAT

SynonymforV_$LOADTSTAT

V$LOCK

SynonymforV_$LOCK

V$LOG

SynonymforV_$LOG

V$LOGFILE

SynonymforV_$LOGFILE

V$LOGHIST

SynonymforV_$LOGHIST

V$LOG_HISTORY

SynonymforV_$LOG_HISTORY

V$MLS_PARAMETERS

SynonymforV_$MLS_PARAMETERS

V$MTS

SynonymforV_$MTS

V$NLS_PARAMETERS

SynonymforV_$NLS_PARAMETERS

V$NLS_VALID_VALUES

SynonymforV_$NLS_VALID_VALUES

V$OPEN_CURSOR

SynonymforV_$OPEN_CURSOR

V$OPTION

SynonymforV_$OPTION

V$PARAMETER

SynonymforV_$PARAMETER

V$PQ_SESSTAT

SynonymforV_$PQ_SESSTAT

V$PQ_SLAVE

SynonymforV_$PQ_SLAVE

V$PQ_SYSSTAT

SynonymforV_$PQ_SYSSTAT

V$PROCESS

SynonymforV_$PROCESS

V$QUEUE

SynonymforV_$QUEUE

V$RECOVERY_LOG

SynonymforV_$RECOVERY_LOG

V$RECOVER_FILE

S