This topic provides an overview of dictionary views in OceanBase Database.
Views related to general database information
| View name | Description |
|---|---|
| DBA_CONTEXT | Displays information about all context namespaces in the database. |
Views related to tables and views
| View name | Description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables accessible to the current user. |
| ALL_COL_COMMENTS | Displays comments on columns of tables accessible to the current user. |
| ALL_TABLES | Displays all tables accessible to the current user. |
| ALL_TAB_COLS | Displays all columns of the tables accessible to the current user. |
| ALL_TAB_COLUMNS | Displays all columns of the tables accessible to the current user. |
| ALL_TAB_COMMENTS | Displays comments on tables accessible to the current user. |
| DBA_TABLES | Displays all tables in the database. |
| DBA_ALL_TABLES | Displays all object tables and relational tables in the database. Its fields are the same as those of ALL_ALL_TABLES. |
| DBA_TABLESPACES | Displays all tablespaces in the database. |
| DBA_TAB_COLS | Displays all columns of all tables in the database. |
| DBA_TAB_COLUMNS | Displays all columns of all tables in the database. |
| USER_ALL_TABLES | Displays object tables and relational tables accessible to the current user. Its fields are the same as those of the ALL_ALL_TABLES view except that it does not have the OWNER field. |
| USER_TABLES | Displays all tables owned by the current user. |
| USER_TABLESPACES | Displays the tablespaces accessible to the current user. Its fields are the same as those of the DBA_TABLESPACES view, except that it does not have the PLUGGED_IN field. |
| USER_TAB_COLS | Displays all columns of the tables owned by the current user. |
| USER_TAB_COLUMNS | Displays all columns of the tables owned by the current user. |
| ALL_VIEWS | Displays the views accessible to the current user. |
| DBA_VIEWS | Displays all views in the database. Its fields are the same as those of ALL_VIEWS. |
| USER_VIEWS | Displays the views owned by the current user. |
Views related to functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | Displays the arguments of the functions and procedures accessible to the current user. |
| ALL_PROCEDURES | Displays all functions and procedures accessible to the current user as well as their properties. |
| ALL_SOURCE | Displays the text sources of the stored objects accessible to the current user. |
| DBA_ARGUMENTS | Displays the arguments of the available functions and procedures in the database. Its fields are the same as those of ALL_ARGUMENTS. |
| DBA_PROCEDURES | Displays all available functions and procedures in the database as well as their properties. Its fields are the same as those of ALL_PROCEDURES. |
| DBA_SOURCE | Displays the text sources of all stored objects in the database. Its fields are the same as those of ALL_SOURCE. |
| USER_ARGUMENTS | Displays the arguments of the functions and procedures owned by the current user. Its fields are the same as those of the ALL_ARGUMENTS view, except that it does not have the OWNER field. |
| USER_PROCEDURES | Displays all functions and procedures owned by the current user, as well as their associated properties. Its fields are the same as those of the ALL_PROCEDURES view, except that it does not have the OWNER field. |
| USER_SOURCE | Displays the text sources of the stored objects owned by the current user. Its fields are the same as those of the ALL_SOURCE view, except that it does not have the OWNER field. |
Views related to statistics and histograms
| View name | Description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | Displays the histograms on all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | Displays the histograms on all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histograms on tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | Displays all table-level histograms. |
| ALL_TAB_STATISTICS | Displays the optimizer statistics of tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables of the database. |
| DBA_PART_HISTOGRAMS | Displays the histograms on partitions of the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables of the database. |
| DBA_SUBPART_HISTOGRAMS | Displays the histograms on the subpartitions of the current database. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables of the database. |
| DBA_TAB_HISTOGRAMS | Displays the table-level histograms on the current database. |
| DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables of the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histograms on the partitions in the partitioned tables of the current user. |
| USER_PART_HISTOGRAMS | Displays the histograms on the partitions of the current user. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on the subpartitions in the partitioned tables of the current user. |
| USER_SUBPART_HISTOGRAMS | Displays the histograms on the subpartitions of the current user. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histograms on the tables of the current user. |
| USER_TAB_HISTOGRAMS | Displays the table-level histograms on the current user. |
| USER_TAB_STATISTICS | Displays the optimizer statistics of all tables of the current user. |
| ALL_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables owned by the current user. |
Views related to users and privileges
| View name | Description |
|---|---|
| ALL_USERS | Displays all database users visible to the current user. |
| DBA_COLL_TYPES | Displays user-defined collection types available in the database. Its fields are the same as those of the ALL_COLL_TYPES view. |
| DBA_USERS | Displays all database users in the database. |
| ALL_COL_PRIVS | |
| ALL_TAB_PRIVS | |
| DBA_COL_PRIVS | Displays all column object privileges in the database. |
| DBA_SYS_PRIVS | Displays the system privileges granted to users and roles. |
| DBA_TAB_PRIVS | Displays all object privileges in the database. |
| USER_COL_PRIVS | Displays the column object privileges for which the current user is the object owner, grantor, or grantee. |
| USER_ROLE_PRIVS | Displays the roles granted to the current user. |
| USER_SYS_PRIVS | Displays the system privileges granted to the current user. |
| ROLE_TAB_PRIVS | Displays the table privileges granted to roles. Information is provided only about roles to which the user has access. |
| ROLE_SYS_PRIVS | Displays the system privileges granted to roles. |
| ROLE_ROLE_PRIVS | Displays the roles granted to other roles. Information is provided only about roles to which the user has access. |
| DBA_ROLE_PRIVS | Displays the roles granted to all users and roles in the database. |
| DBA_ROLES | Displays all roles that exist in the database. |
Views related to constraints
| View name | Description |
|---|---|
| ALL_CONSTRAINTS | Displays the constraints on all tables accessible to the current user. |
| ALL_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables accessible to the current user. |
| DBA_CONSTRAINTS | Displays the constraints on all tables in the database. |
| DBA_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables in the database. |
| USER_CONSTRAINTS | Displays the constraints on all tables owned by the current user. |
| USER_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables owned by the current user. |
Views related to auditing
| View name | Description |
|---|---|
| ALL_DEF_AUDIT_OPTS | Displays the default object-auditing conditions for any object. |
| AUDIT_ACTIONS | Displays the action IDs and names in audit records. |
| DBA_AUDIT_EXISTS | Displays audit trail entries produced by AUDIT EXISTS and AUDIT NOT EXISTS. |
| DBA_AUDIT_OBJECT | Displays the audit trail records for all objects in the database. |
| DBA_AUDIT_SESSION | Displays all audit trail records concerning CONNECT and DISCONNECT. |
| DBA_AUDIT_STATEMENT | Displays audit trail records concerning the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | Displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | Displays detailed auditing configurations at the object level. |
| DBA_STMT_AUDIT_OPTS | Displays detailed auditing configuration at the statement level. |
| STMT_AUDIT_OPTION_MAP | Displays statement-level auditing types, names, and priorities. |
| USER_AUDIT_OBJECT | Displays audit trail records for objects accessible to the current user. |
| USER_AUDIT_SESSION | Displays audit trail records for connections and disconnections of the current user. |
| USER_AUDIT_STATEMENT | Displays audit trail entries for the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | Displays standard audit trail entries concerning the current user. |
Views related to indexes
| View name | Description |
|---|---|
| ALL_INDEXES | Displays the indexes on all tables accessible to the current user. |
| ALL_IND_COLUMNS | Displays the indexes on all tables accessible to the current user. |
| ALL_IND_EXPRESSIONS | Displays information about function-based indexes accessible to the current user in the database. |
| ALL_IND_PARTITIONS | Displays information about index partitions accessible to the current user in the database. |
| ALL_IND_SUBPARTITIONS | Displays information about all index subpartitions accessible to the current user in the database. |
| ALL_PART_INDEXES | Displays the partitioning information of all partitioned indexes accessible to the current user. |
| DBA_INDEXES | Displays the indexes on all tables in the database. |
| DBA_IND_COLUMNS | Displays the columns of indexes on all tables in the database. |
| DBA_IND_EXPRESSIONSc | Displays information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Displays information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | Displays information about all index subpartitions in the database. |
| USER_INDEXES | Displays the indexes on all tables owned by the current user. |
| USER_IND_COLUMNS | Displays the columns of indexes on all tables owned by the current user. |
| USER_IND_EXPRESSIONS | Displays information about function-based indexes owned by the current user in the database. |
| USER_IND_PARTITIONS | Displays information about the index partitions owned by the current user in the database. This view does not have the INDEX_OWNER field compared with the ALL_IND_PARTITIONS and DBA_IND_PARTITIONS views. |
| USER_IND_SUBPARTITIONS | Displays information about all index subpartitions owned by the current user in the database. This view does not have the INDEX_OWNER field compared with the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views. |
| USER_PART_INDEXES | Displays the partitioning information of partitioned indexes owned by the current user. |
Views related to partitions
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | Displays the partition-level partitioning information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for the partitions accessible to the current user. |
| DBA_PART_INDEXES | Displays the partitioning information of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| DBA_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | Displays the partitioning key columns in all partitioned objects owned by the current user. |
| USER_PART_TABLES | Displays the partitioning information of all partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | Displays information about all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | Displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes. |
| USER_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of the current user. |
Views related to sequences
| View name | Description |
|---|---|
| ALL_SEQUENCES | Displays all sequences accessible to the current user. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
Views related to synonyms
| View name | Description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms accessible to the current user. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays all synonyms owned by the current user. |
Views related to triggers
| View name | Description |
|---|---|
| ALL_TRIGGERS DBA_TRIGGERS | Displays the triggers on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view displays all the triggers in the database. |
| DBA_TRIGGERS | Displays all triggers in the database. |
| USER_TRIGGERS | Displays the triggers owned by the current user. |
Views related to comments
| View name | Description |
|---|---|
| DBA_COL_COMMENTS | Displays the comments on all columns of all tables and views in the database. |
| ALL_TAB_COMMENTS | Displays comments on tables and views accessible to the current user. |
| DBA_TAB_COMMENTS | Displays the comments on all tables and views in the database. |
| USER_COL_COMMENTS | Displays the comments on all columns of the tables and views owned by the current user. |
| USER_TAB_COMMENTS | Displays the comments on tables and views owned by the current user. |
Views related to recycle bins
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | Displays information about all recycle bins in the database. |
| USER_RECYCLEBIN | Displays information about recycle bins owned by the current user. Its fields are the same as those of the DBA_RECYCLEBIN view, except that it does not have the OWNER field. |
Views related to resource groups
| View name | Description |
|---|---|
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationships between the user and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Displays information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all resource management plans defined in the system. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details of each group of resource plan directives in the database. |
Views related to NLS parameters
| View name | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays the National Language Support (NLS) parameters at the OceanBase Database tenant level. |
| NLS_INSTANCE_PARAMETERS | Displays the NLS parameters at the instance level. |
| NLS_SESSION_PARAMETERS | Displays the NLS parameters at the session level. |
Views related to user-defined types
| View name | Description |
|---|---|
| ALL_COLL_TYPES | Displays user-defined collection types available in the database. Its fields are the same as those of the DBA_COLL_TYPES view. |
| ALL_TYPES | Displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| DBA_COLL_TYPES | Displays user-defined collection types available in the database. Its fields are the same as those of the ALL_COLL_TYPES view. |
| DBA_TYPES | Displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| USER_COLL_TYPES | Displays the user-defined collection types accessible to the current user. |
| USER_TYPES | Displays the user-defined types accessible to the current user. |
| USER_TYPE_ATTRS | Displays the attributes of user-defined types accessible to the current user. |
Views related to stored objects
| View name | Description |
|---|---|
| ALL_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
| DBA_ERRORS | Displays the current errors of all stored objects in the database. |
| USER_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
Views related to profiles
| View name | Description |
|---|---|
| ALL_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| DBA_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| USER_PROFILES | Displays all profiles accessible to the current user and their limitations. |
Other views
| View name | Description |
|---|---|
| ALL_OBJECTS | Displays all database objects accessible to the current user. |
| ALL_DEPENDENCIES | Displays the dependencies among all the objects accessible to the current user. At present, only dependencies among Procedural Language (PL) objects are displayed. |
| DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| DBA_SEGMENTS | Displays the storage allocated for all segments in the database. |
| DBA_DEPENDENCIES | Displays the dependencies among all objects in the database. At present, only dependencies among PL objects are displayed. |
| USER_OBJECTS | Displays all database objects owned by the current user. Its fields are the same as those of the ALL_OBJECTS view, except that it does not have the OWNER field. This is because the owner is the current user. |
| USER_SEGMENTS | Displays the storage allocated for the segments of the objects that are owned by the current user. |
| USER_DEPENDENCIES | Displays the dependencies among objects in the schema of the current user. At present, only dependencies among Procedural Language (PL) objects are displayed. |
| DICTIONARY | Displays the data dictionary tables and views. |
| DICT | Displays the data dictionary tables and views. Its fields are the same as those of the DICTIONARY view. |
| ALL_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_JOBS | Displays an overview of committed jobs. |
| DBA_JOBS_RUNNING | Displays the running jobs. |
| DBA_SCHEDULER_JOBS | Displays the scheduler jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | Displays all scheduler programs in the database. |
Unsupported views
| View name | Description |
|---|---|
| ALL_METHOD_PARAMS | Displays the method parameters of the object types accessible to the current user. |
| ALL_SCHEDULER_JOB_ARGS | Displays the arguments of all scheduler jobs accessible to the current user. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the arguments of scheduler programs accessible to the current user. |
| ALL_TYPE_METHODS | Displays the methods of the object types accessible to the current user. |
| DBA_METHOD_PARAMS | Displays the method parameters of the object types in the database. |
| DBA_SCHEDULER_JOB_ARGS | Displays the arguments of all scheduler jobs in the database. |
| DBA_SCHEDULER_PROGRAM_ARGS | Displays the arguments of all scheduler programs in the database. |
| DBA_TYPE_METHODS | Displays the methods of all object types in the database. |
| USER_TYPE_METHODS | Displays the methods of the object types accessible to the current user. Its fields are the same as those of the ALL_TYPE_METHODS view, except that it does not have the OWNER field. |