打印本文 打印本文 关闭窗口 关闭窗口
Oracle常用数据字典
作者:武汉SEO闵涛  文章来源:敏韬网  点击数2458  更新时间:2009/4/22 22:04:42  文章录入:mintao  责任编辑:mintao
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

上一页  [1] [2] [3]  下一页

打印本文 打印本文 关闭窗口 关闭窗口