Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The oceanbase.DBA_OBJECTS view displays all objects in a database. The definition of this view is consistent with that of the ALL_OBJECTS view.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | varchar(128) | NO | The owner of the object. |
| OBJECT_NAME | varchar(128) | NO | The name of the object. |
| SUBOBJECT_NAME | varchar(128) | NO | The name of the subobject, such as partition. |
| OBJECT_ID | bigint(20) | NO | The dictionary object ID of the object. |
| DATA_OBJECT_ID | bigint(20) | NO | The dictionary object ID of the segment that contains the object. |
| OBJECT_TYPE | varchar(23) | NO | The type of the object, such as table, index, partition, package, stored procedure, synonym, or sequence. |
| CREATED | datetime | NO | The time when the object was created. |
| LAST_DDL_TIME | datetime | NO | The time when the object was last modified by using a DDL statement. |
| TIMESTAMP | datetime | NO | The timestamp specified by the object, which is generated as a character. |
| STATUS | varchar(7) | NO | The status of the object. Valid values: |
| TEMPORARY | varchar(1) | NO | Indicates whether the object is a temporary table. |
| GENERATED | varchar(1) | NO | Indicates whether the name of the object was system-generated. |
| SECONDARY | varchar(1) | NO | At present, this column is not used. |
| NAMESPACE | bigint(1) | NO | The namespace for the object. |
| EDITION_NAME | varchar(128) | NO | Reserved for future use. |
| SHARING | varchar(18) | NO | Valid values:DATA LINK: The object is a data link or an object whose data is linked to the root.METADATA LINK: The object is a metadata link or an object whose metadata is linked to the root.EXTENDED DATA LINK: The object is an extended data link or an object whose data link is extended to the root.NONE: None of the above applies. |
| EDITIONABLE | varchar(1) | NO | Valid values:Y: The object is marked as EDITIONABLE.N: The object is marked as NONEDITIONABLE.NULL: The object type is not editable in the database. |
| ORACLE_MAINTAINED | varchar(1) | NO | Indicates whether the object is created and maintained by a script provided by Oracle, such as catalog.sql or catproc.sql. Objects with a value of Y in this column can only be modified by running a script provided by Oracle. They cannot be modified in any other ways. |
| APPLICATION | varchar(1) | NO | Indicates whether the object is a common object for an application. Valid values: |
| DEFAULT_COLLATION | varchar(1) | NO | The default sorting rule of the object. |
| DUPLICATED | varchar(1) | NO | Indicates whether the object is duplicated on this shard. Valid values: |
| SHARDED | varchar(1) | NO | Indicates whether the object is sharded. Valid values: |
| IMPORTED_OBJECT | varchar(1) | NO | Indicates whether the object has been imported. Valid values: |
| CREATED_APPID | bigint(0) | NO | The ID of the application that created the object. |
| CREATED_VSNID | bigint(0) | NO | The version ID of the application that created the object. |
| MODIFIED_APPID | bigint(0) | NO | The ID of the application that modified the object the last time. |
| MODIFIED_VSNID | bigint(0) | NO | The version ID of the application that modified the object the last time. |
Sample query
Query information about all objects in the specified database.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OBJECTS limit 1 \G
The query result is as follows:
*************************** 1. row ***************************
OWNER: oceanbase
OBJECT_NAME: oceanbase
SUBOBJECT_NAME: NULL
OBJECT_ID: 202001
DATA_OBJECT_ID: NULL
OBJECT_TYPE: TABLEGROUP
CREATED: 2024-05-08 14:20:29
LAST_DDL_TIME: 2024-05-08 14:20:29
TIMESTAMP: 2024-05-08 14:20:29
STATUS: VALID
TEMPORARY: N
GENERATED: N
SECONDARY: N
NAMESPACE: 0
EDITION_NAME: NULL
SHARING: NULL
EDITIONABLE: NULL
ORACLE_MAINTAINED: NULL
APPLICATION: NULL
DEFAULT_COLLATION: NULL
DUPLICATED: NULL
SHARDED: NULL
IMPORTED_OBJECT: NULL
CREATED_APPID: NULL
CREATED_VSNID: NULL
MODIFIED_APPID: NULL
MODIFIED_VSNID: NULL
1 row in set (0.087 sec)