Note
This view was introduced in OceanBase Database V2.2.77.
Purpose
The USER_OBJECTS view displays all database objects owned by the current user. Its columns are the same as those of the ALL_OBJECTS view, except that it does not have the OWNER column. This is because the owner is the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | 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 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 object. |
| 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 | The value of this column is NULL by default. |
| EDITIONABLE | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| ORACLE_MAINTAINED | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| APPLICATION | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| DEFAULT_COLLATION | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| DUPLICATED | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| SHARDED | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| IMPORTED_OBJECT | VARCHAR2(1) | NO | The value of this column is NULL by default. |
| CREATED_APPID | NUMBER | NO | The value of this column is NULL by default. |
| CREATED_VSNID | NUMBER | NO | The value of this column is NULL by default. |
| MODIFIED_APPID | NUMBER | NO | The value of this column is NULL by default. |
| MODIFIED_VSNID | NUMBER | NO | The value of this column is NULL by default. |
Sample query
obclient [SYS]> SELECT * FROM SYS.USER_OBJECTS WHERE ROWNUM <= 2;
The query result is as follows:
+----------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| OBJECT_NAME | SUBOBJECT_NAME | OBJECT_ID | DATA_OBJECT_ID | OBJECT_TYPE | CREATED | LAST_DDL_TIME | TIMESTAMP | STATUS | TEMPORARY | GENERATED | SECONDARY | NAMESPACE | EDITION_NAME | SHARING | EDITIONABLE | ORACLE_MAINTAINED | APPLICATION | DEFAULT_COLLATION | DUPLICATED | SHARDED | IMPORTED_OBJECT | CREATED_APPID | CREATED_VSNID | MODIFIED_APPID | MODIFIED_VSNID |
+----------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| ALL_ALL_TABLES | NULL | 25086 | NULL | VIEW | 05-JAN-24 | 05-JAN-24 | 05-JAN-24 02.35.06. | VALID | N | Y | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| ALL_ARGUMENTS | NULL | 25057 | NULL | VIEW | 05-JAN-24 | 05-JAN-24 | 05-JAN-24 02.35.06. | VALID | N | Y | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+----------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
2 rows in set