Purpose
The ALL_OBJECTS view displays all database objects accessible to the current user.
Applicability
This content is only applicable to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides the MySQL mode.
Related views
USER_OBJECTS
DBA_OBJECTS
Columns
| Column | 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, such as 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, such as 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. |
| 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 column is not used. |
| NAMESPACE | NUMBER | NO | The namespace for the object. |
| EDITION_NAME | VARCHAR2(128) | NO | Reserved for future use. |
| SHARING | VARCHAR2(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 | VARCHAR2(1) | NO | Valid values:Y: The object is marked as EDITIONABLE.N: The object is marked as NONEDITIONABLE. |
| ORACLE_MAINTAINED | VARCHAR2(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 | 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. |