Note
This view is available starting with V4.0.0.
Overview
The DBA_OBJECTS view displays all database objects for the current tenant. Its definition is the same as that of the ALL_OBJECTS view.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | Owner of the object |
| OBJECT_NAME | varchar(128) | NO | Object Name |
| SUBOBJECT_NAME | varchar(128) | NO | Subobject name (for example, partition) |
| OBJECT_ID | bigint(20) | NO | Dictionary ID of the object |
| DATA_OBJECT_ID | bigint(20) | NO | Dictionary ID of the segment containing this object |
| OBJECT_TYPE | varchar(23) | NO | Object types, including tables, indexes, partitions, packages, stored procedures, synonyms, sequences, etc. |
| CREATED | datetime | NO | Object creation time |
| LAST_DDL_TIME | datetime | NO | Last DDL Time of Object |
| TIMESTAMP | datetime | NO | The timestamp specified by the object, output as a character |
| STATUS | varchar(7) | NO | Object status:
|
| TEMPORARY | varchar(1) | NO | Whether this object is a temporary object. |
| GENERATED | varchar(1) | NO | Whether the object name is generated by the system. |
| SECONDARY | varchar(1) | NO | This field is not currently used. |
| NAMESPACE | bigint(1) | NO | Object Namespace |
| EDITION_NAME | varchar(128) | NO | Reserved Fields |
| SHARING | varchar(18) | NO | The default value of this field isNULL |
| EDITIONABLE | varchar(1) | NO | The default value of this field isNULL |
| ORACLE_MAINTAINED | varchar(1) | NO | The default value of this field isNULL |
| APPLICATION | varchar(1) | NO | The default value of this field isNULL |
| DEFAULT_COLLATION | varchar(1) | NO | The default value of this field isNULL |
| DUPLICATED | varchar(1) | NO | The default value of this field isNULL |
| SHARDED | varchar(1) | NO | The default value of this field isNULL |
| IMPORTED_OBJECT | varchar(1) | NO | The default value of this field isNULL |
| CREATED_APPID | bigint(0) | NO | The default value of this field isNULL |
| CREATED_VSNID | bigint(0) | NO | The default value of this field isNULL |
| MODIFIED_APPID | bigint(0) | NO | The default value of this field isNULL |
| MODIFIED_VSNID | bigint(0) | NO | The default value of this field isNULL |
Sample query
Query all database objects in the current tenant and display the first two records.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OBJECTS limit 2;
The query result is as follows:
+-----------+---------------------------+----------------+-----------+----------------+-------------+---------------------+---------------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| OWNER | OBJECT_NAME | SUBOBJECT_NAME | OBJECT_ID | DATA_OBJECT_ID | OBJECT_TYPE | CREATED | LAST_DDL_TIME | TIMESTAMP | STATUS | TEMPORARY | GENERATED | SECONDARY | NAMESPACE | EDITION_NAME | SHARING | EDITIONABLE | ORACLE_MAINTAINED | APPLICATION | DEFAULT_COLLATION | DUPLICATED | SHARDED | IMPORTED_OBJECT | CREATED_APPID | CREATED_VSNID | MODIFIED_APPID | MODIFIED_VSNID |
+-----------+---------------------------+----------------+-----------+----------------+-------------+---------------------+---------------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| oceanbase | __all_core_table | NULL | 1 | 1 | TABLE | 2024-01-05 14:33:03 | 2024-01-05 14:33:03 | 2024-01-05 14:33:03 | VALID | N | N | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| oceanbase | __idx_3_idx_data_table_id | NULL | 100001 | 100001 | TABLE | 2024-01-05 14:33:03 | 2024-01-05 14:33:03 | 2024-01-05 14:33:03 | VALID | N | N | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+-----------+---------------------------+----------------+-----------+----------------+-------------+---------------------+---------------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
2 rows in set (0.131 sec)