Note
This view was introduced in OceanBase Database V4.0.0.
Purpose
The oceanbase.CDB_OBJECTS view displays the information about objects of all tenants in the sys tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| 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: VALID and INVALID. |
| TEMPORARY | varchar(1) | NO | Indicates whether the object is a temporary object. |
| 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(20) | NO | The namespace for the object. |
| EDITION_NAME | varchar(128) | NO | Reserved for future use. |
| SHARING | varchar(18) | NO | The value of this column is NULL by default. |
| EDITIONABLE | varchar(1) | NO | The value of this column is NULL by default. |
| ORACLE_MAINTAINED | varchar(1) | NO | The value of this column is NULL by default. |
| APPLICATION | varchar(1) | NO | The value of this column is NULL by default. |
| DEFAULT_COLLATION | varchar(1) | NO | The value of this column is NULL by default. |
| DUPLICATED | varchar(1) | NO | The value of this column is NULL by default. |
| SHARDED | varchar(1) | NO | The value of this column is NULL by default. |
| IMPORTED_OBJECT | varchar(1) | NO | The value of this column is NULL by default. |
| CREATED_APPID | bigint(0) | NO | The value of this column is NULL by default. |
| CREATED_VSNID | bigint(0) | NO | The value of this column is NULL by default. |
| MODIFIED_APPID | bigint(0) | NO | The value of this column is NULL by default. |
| MODIFIED_VSNID | bigint(0) | NO | The value of this column is NULL by default. |