Feature
ALL_OBJECTS displays all database objects accessible to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
USER_OBJECTS
DBA_OBJECTS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the object. |
| SUBOBJECT_NAME | VARCHAR2(128) | NO | The name of the subobject (for example, partition). |
| OBJECT_ID | NUMBER | NO | The dictionary object ID of the object. |
| DATA_OBJECT_ID | NUMBER | NO | The dictionary object ID of the segment that contains the object. |
| OBJECT_TYPE | VARCHAR2(23) | NO | The type of the object, for example, table, index, partition, package, stored procedure, synonym, or sequence. |
| CREATED | DATE | NO | The time when the object was created. |
| LAST_DDL_TIME | DATE | NO | The time when the object was last modified by using a DDL statement. |
| TIMESTAMP | VARCHAR2(19) | NO | The timestamp specified by the object, which is generated as a character. |
| STATUS | VARCHAR2(7) | NO | The status of the object. Valid values: |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the object is a temporary table. |
| GENERATED | VARCHAR2(1) | NO | Indicates whether the name of the object was system-generated. |
| SECONDARY | VARCHAR2(1) | NO | This field is not used now. |
| NAMESPACE | NUMBER | NO | The namespace for the object. |
| EDITION_NAME | VARCHAR2(128) | NO | Reserved for future use. |
| SHARING | VARCHAR2(18) | NO | Valid values: |
| EDITIONABLE | VARCHAR2(1) | NO | Valid values: |
| ORACLE_MAINTAINED | VARCHAR2(1) | NO | Indicates whether the object is created and maintained by a script provided by Oracle, for example, 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, and cannot be modified in any other way. |
| APPLICATION | VARCHAR2(1) | NO | Indicates whether the object is a common object for an application. Valid values: |
| DEFAULT_COLLATION | VARCHAR2(1) | NO | The default sorting rule of the object. |
| DUPLICATED | VARCHAR2(1) | NO | Indicates whether the object is duplicated on this shard. Valid values: |
| SHARDED | VARCHAR2(1) | NO | Indicates whether the object is sharded. Valid values: |
| IMPORTED_OBJECT | VARCHAR2(1) | NO | Indicates whether the object has been imported. Valid values: |
| CREATED_APPID | NUMBER | NO | The ID of the application that created the object. |
| CREATED_VSNID | NUMBER | NO | The version ID of the application that created the object. |
| MODIFIED_APPID | NUMBER | NO | The ID of the application that modified the object the last time. |
| MODIFIED_VSNID | NUMBER | NO | The version ID of the application that modified the object the last time. |