Feature
USER_OBJECTS displays all database objects owned by the current user. Its fields are the same as those of the ALL_OBJECTS view, except that it does not have the OWNER field. This is because the owner is the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_OBJECTS
DBA_OBJECTS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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 Data Definition Language (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 | Reserved for future use. |
| 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, 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. |
| 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. |