データ・ディクショナリ・リスト
このリストはゆかたんのローカルマシンでリストしました。
使用しているシステムの現行のデータ・ディクショナリを参照するには、ビューDICTIONARYを問い合せよ
日本語の解説が見たいときはOracle７管理者ガイドをみてね
| ALL_ARGUMENTS | Arguments in object accessible to the user |
| ALL_CATALOG | All tables, views, synonyms, sequences accessible to the user |
| ALL_CLUSTERS | Description of clusters accessible to the user |
| ALL_CLUSTER_HASH_EXPRESSIONS | Hash functions for all accessible clusters |
| 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_HISTOGRAMS | Histograms on columns of all tables visible to user |
| 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 user's 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_UPDATABLE_COLUMNS | Description of all updatable columns |
| ALL_USERS | Information about all users of the database |
| ALL_VIEWS | Text of views accessible to the user |
| DBA_2PC_NEIGHBORS | information about incoming and outgoing connections for pending transactions |
| DBA_2PC_PENDING | info about distributed transactions awaiting recovery |
| DBA_ANALYZE_OBJECTS | |
| DBA_AUDIT_DBA | Audit trail entries created by AUDIT DBA |
| DBA_AUDIT_EXISTS | Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS |
| DBA_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 |
| DBA_AUDIT_SESSION | All audit trail records concerning CONNECT and DISCONNECT |
| DBA_AUDIT_STATEMENT | Audit trail records concerning grant, revoke, audit, noaudit and alter system |
| DBA_AUDIT_TRAIL | All audit trail entries |
| DBA_CATALOG | All database Tables, Views, Synonyms, Sequences |
| DBA_CLUSTERS | Description of all clusters in the database |
| DBA_CLUSTER_HASH_EXPRESSIONS | Hash functions for all clusters |
| DBA_CLU_COLUMNS | Mapping of table columns to cluster columns |
| DBA_COL_COMMENTS | Comments on columns of all tables and views |
| DBA_COL_GRANTS | All grants on columns in the database |
| DBA_COL_PRIVS | All grants on columns in the database |
| DBA_CONSTRAINTS | Constraint definitions on all tables |
| DBA_CONS_COLUMNS | Information about accessible columns in constraint definitions |
| DBA_CROSS_REFS | Cross reference of all views and synonyms |
| DBA_DATA_FILES | Information about database files |
| DBA_DB_LINKS | All database links in the database |
| DBA_DEPENDENCIES | Dependencies to and from objects |
| DBA_ERRORS | Current errors on all stored objects in the database |
| DBA_EXP_FILES | Description of export files |
| DBA_EXP_OBJECTS | Objects that have been incrementally exported |
| DBA_EXP_VERSION | Version number of the last export session |
| DBA_EXTENTS | Extents comprising all segments in the database |
| DBA_FREE_SPACE | Free extents in all tablespaces |
| DBA_FREE_SPACE_COALESCED | Statistics on Coalesced Space in Tablespaces |
| DBA_FREE_SPACE_COALESCED_TMP1 | Coalesced Free Extents for all Tablespaces |
| DBA_FREE_SPACE_COALESCED_TMP2 | Free Extents in Tablespaces |
| DBA_HISTOGRAMS | Histograms on columns of all tables |
| DBA_INDEXES | Description for all indexes in the database |
| DBA_IND_COLUMNS | COLUMNs comprising INDEXes on all TABLEs and CLUSTERs |
| DBA_JOBS | All jobs in the database |
| DBA_JOBS_RUNNING | All jobs in the database which are currently running, join v$lock and job$ |
| DBA_OBJECTS | All objects in the database |
| DBA_OBJECT_SIZE | Sizes, in bytes, of various pl/sql objects |
| DBA_OBJ_AUDIT_OPTS | Auditing options for all tables and views |
| DBA_PRIV_AUDIT_OPTS | Describes current system privileges being audited across the system and by user |
| DBA_PROFILES | Display all profiles and their limits |
| DBA_RCHILD | All the children in any refresh group. This view is not a join. |
| DBA_REFRESH | All the refresh groups |
| DBA_REFRESH_CHILDREN | All the objects in refresh groups |
| DBA_RGROUP | All refresh groups. This view is not a join. |
| DBA_ROLES | All Roles which exist in the database |
| DBA_ROLE_PRIVS | Roles granted to users and roles |
| DBA_ROLLBACK_SEGS | Description of rollback segments |
| DBA_SEGMENTS | Storage allocated for all database segments |
| DBA_SEQUENCES | Description of all SEQUENCEs in the database |
| DBA_SNAPSHOTS | All snapshots in the database |
| DBA_SNAPSHOT_LOGS | All snapshot logs in the database |
| DBA_SOURCE | Source of all stored objects in the database |
| DBA_STMT_AUDIT_OPTS | Describes current system auditing options across the system and by user |
| DBA_SYNONYMS | All synonyms in the database |
| DBA_SYS_PRIVS | System privileges granted to users and roles |
| DBA_TABLES | Description of all tables in the database |
| DBA_TABLESPACES | Description of all tablespaces |
| DBA_TAB_AUDIT_OPTS | Auditing options for all tables and views |
| DBA_TAB_COLUMNS | Columns of user's tables, views and clusters |
| DBA_TAB_COMMENTS | Comments on all tables and views in the database |
| DBA_TAB_GRANTS | All grants on objects in the database |
| DBA_TAB_PRIVS | All grants on objects in the database |
| DBA_TRIGGERS | All triggers in the database |
| DBA_TRIGGER_COLS | Column usage in all triggers |
| DBA_TS_QUOTAS | Tablespace quotas for all users |
| DBA_UPDATABLE_COLUMNS | Description of dba updatable columns |
| DBA_USERS | Information about all users of the database |
| DBA_VIEWS | Text of all views in the database |
| USER_ARGUMENTS | Arguments in object 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 | All audit trail records concerning CONNECT and DISCONNECT |
| 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_CLUSTER_HASH_EXPRESSIONS | Hash functions for the user's hash 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_HISTOGRAMS | Histograms on columns of user's tables |
| 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_UPDATABLE_COLUMNS | Description of updatable columns |
| 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 |
| NLS_DATABASE_PARAMETERS | Permanent NLS parameters of the database |
| NLS_INSTANCE_PARAMETERS | NLS parameters of the instance |
| NLS_SESSION_PARAMETERS | NLS parameters of the user session |
| 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 |
| 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$ACTIVE_INSTANCES | Synonym for V_$ACTIVE_INSTANCES |
| 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$DB_PIPES | Synonym for V_$DB_PIPES |
| V$DISPATCHER | Synonym for V_$DISPATCHER |
| V$ENABLEDPRIVS | Synonym for V_$ENABLEDPRIVS |
| V$EVENT_NAME | Synonym for V_$EVENT_NAME |
| V$EXECUTION | Synonym for V_$EXECUTION |
| V$FILESTAT | Synonym for V_$FILESTAT |
| V$FIXED_TABLE | Synonym for V_$FIXED_TABLE |
| V$FIXED_VIEW_DEFINITION | Synonym for V_$FIXED_VIEW_DEFINITION |
| V$INDEXED_FIXED_COLUMN | Synonym for V_$INDEXED_FIXED_COLUMN |
| V$INSTANCE | Synonym for V_$INSTANCE |
| V$LATCH | Synonym for V_$LATCH |
| V$LATCHHOLDER | Synonym for V_$LATCHHOLDER |
| V$LATCHNAME | Synonym for V_$LATCHNAME |
| V$LATCH_CHILDREN | Synonym for V_$LATCH_CHILDREN |
| V$LATCH_MISSES | Synonym for V_$LATCH_MISSES |
| V$LATCH_PARENT | Synonym for V_$LATCH_PARENT |
| 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$LOCKED_OBJECT | Synonym for V_$LOCKED_OBJECT |
| 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$MYSTAT | Synonym for V_$MYSTAT |
| V$NLS_PARAMETERS | Synonym for V_$NLS_PARAMETERS |
| V$NLS_VALID_VALUES | Synonym for V_$NLS_VALID_VALUES |
| V$OBJECT_DEPENDENCY | Synonym for V_$OBJECT_DEPENDENCY |
| 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$PQ_TQSTAT | Synonym for V_$PQ_TQSTAT |
| V$PROCESS | Synonym for V_$PROCESS |
| V$PWFILE_USERS | Synonym for V_$PWFILE_USERS |
| V$QUEUE | Synonym for V_$QUEUE |
| V$RECOVERY_FILE_STATUS | Synonym for V_$RECOVERY_FILE_STATUS |
| V$RECOVERY_LOG | Synonym for V_$RECOVERY_LOG |
| V$RECOVERY_STATUS | Synonym for V_$RECOVERY_STATUS |
| 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_CONNECT_INFO | Synonym for V_$SESSION_CONNECT_INFO |
| 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_POOL_RESERVED | Synonym for V_$SHARED_POOL_RESERVED |
| V$SHARED_SERVER | Synonym for V_$SHARED_SERVER |
| V$SORT_SEGMENT | Synonym for V_$SORT_SEGMENT |
| V$SQL | Synonym for V_$SQL |
| V$SQLAREA | Synonym for V_$SQLAREA |
| V$SQLTEXT | Synonym for V_$SQLTEXT |
| V$SQLTEXT_WITH_NEWLINES | Synonym for V_$SQLTEXT_WITH_NEWLINES |
| V$SQL_BIND_DATA | Synonym for V_$SQL_BIND_DATA |
| V$SQL_BIND_METADATA | Synonym for V_$SQL_BIND_METADATA |
| V$SQL_CURSOR | Synonym for V_$SQL_CURSOR |
| V$SQL_SHARED_MEMORY | Synonym for V_$SQL_SHARED_MEMORY |
| 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$SYSTEM_PARAMETER | Synonym for V_$SYSTEM_PARAMETER |
| 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 |